Hi ,

We have a project where we FastExport data from one Teradata Server and Mload/Fastload it to another Teradata Server.However I recently found out we also have TDM available in our project.

I was wondering whether it is worth to change existing Fexp/FastLoad scripts to TDM or would the performance be nearly same in both the case.

hi,pls convert the following SQL queries to Teradata SQL.1.DATEDIFF(day,dateadd ( dd , ( r_update_date % 1000 ) - 1 , convert ( datetime ,convert( char(4) , r_update_date / 1000 ) + '/01/01') ) , GETDATE()) > 902. datepart(d,dateadd(day,-datepart(d,getdate()),getdate());

Hi,while firing the below sql, I am getting 'Numeric Overflow Occured during computation'Select A ,B ,C ,D ,E ,sum(F) AS G ,sum(H) AS I from dbname.tblname WHERE D <> 'R' group by 1,2,3,4,5order by 1,2,3,4,5Pls help!

Where are fastload worktables stored?does it take perm space?can we actually see those tables in list of objects being created?In which DBC table those worktables are stored?

Hi Gurus,
Please help me suggesting a query to find for pulling all the tables and Views in teradata .
we have lot of backed up  temp tables and views not using in prod since from long time.
 
Please find the below SQL's
 

Hi,I am trying to convert Stored procedure from Sybase to Teradata. Sybase has the option to raise error as well as return 0 or 1 for (success or failure).The scenario is as follows,1) SP1 2) SP2Call of SP2 depends on the return value generated by SP1 ,for eg, create procedure SP1(@z char(2))as if (char_length(@z," ") <> 2) begin raiserror 20000 return 1 end return 0exec @retcode=SP1 @zIF @retcode = 0 exec @retcode=SP2 @zELSE return 1So here in this case, if the return value is 1, then the other stored procedure shall not execute and if its 0 then SP2 would get executed. This functionality is supported by Sybase.I tried implementing the same functionality in Teradata using OUT parameter.However when the stored procedure SP1 executes successfully the out parameters set to 0, but if SP1 fails with error the OUT parameter doesn't return any value.Please help in this regard.

Hi,
I am using TPT to load my table.
I am facing an error in converting varchar to TimeStamp(0).
The segment code which is giving the error is :
STEP LOAD_DATA_INTO_TABLE
(
   APPLY ('INSERT INTO '||@TargetTable||'(
          :IDNT_TICK,
    :MSG_ID,

can any one please give me a sample script to load a table using bteq import?Thanks in adv.

Hi,i want to get all columnnames from a table A & its respective datatype.i could get it columnnamefrom below querysel columnname from dbc.columnswhere tablename ='A'and databasename = 'dtbs'how can i get respective datatype?Please help me.Thanks,altruist

Is anyone ETL'ing a clob from Oracle to Teradata or does anyone have any thoughts how one would? What strategies are you using?

Hi,
 
We use TASM to limit duration and spool of some Requests.
We would like to set a continue handler for 3156 Code (coming from TASM when request limit is exceeded) but we are not able to make it work. It works for others errors not coming from TASM.
Do you have an Idea on this subject ?
Thanks a lot
Best Regards

Is any one in this forum using Metadata Services? We are looking to work with it but wanted to get some info on those that are using it and their experience? what they use it for and how they use it. Any info will help.

I work in a Data Warehouse as a Quality Control Analyst. Development uses Abinitio as the ETL tool and we use SQL for writing our test scripts. I am trying to find out how other shops test their existing Data Warehouse maintenance projects. We use the functional and technical specifications to create our Test Strategy, Test Plans and Test Cases. We use a subset of production data for our test bed. We test all of the transformation rules stated in the specifications (some have very complex logic), creating ‘seeded’ test data to meet the criteria of the transformation rule if the data does not already exist. My Questions: How are other shops meeting the need to test all the transformation rules? Are other shops seeding data or only using what exists in production? If all transformation rules are not being tested is there a risk factor associated with the untested rules? In your environment does the Developer run the ETL graphs for loading test target tables or does your Testers run the graphs? Thanks.

HiCan you please help me convert char(16) to decimal(18,0)e.g. select Cast(OAA_N as decimal (18,0) ) O_Account_Num from AccountError: It says bad character formatting.

Hi,
    Is it possible to pass an array to a teradata (13) stored procedure?  If I had to do it in oracle, it would look as follows:
 
 

create or replace

TYPE T_STR_ARRAY AS TABLE OF varchar2(6);

 PROCEDURE p_AcceptArray( inArrayCdes in T_STR_ARRAY ) IS.....etc

Any help would be greatly appreciated

Hello experts,We have received an arcmain dump(of only table definitions of all tables expect DBC) from one of our teradata servers. We have imported the same into our dev environment. For the first time, the import has failed as one of the databases has too little permanent space even to create empty tables. and later, once we allocated the space, we re-ran the job and it was successful. But, we are not able to access any table and we are getting the following error. "2654: Operation not allowed: is being restored."Below is one of the sample scripts that we have used. (we have imported around 10000+ objects with a similar query)LOGON dbc/userid,password;COPY DICTIONARY TABLE (database.tablename) (FROM (database.tablename)),RELEASE LOCK,FILE=BKP ;LOGOFF;Has anyone faced this issue before? Let me know what could be the potential problem. Appreciate your help in this and thanks in advance.RegardsKondal

I have a column in source strdate1 as VARCHAR(23) and the value being '20090310181010'.I am unable to insert this record into target table column whose data type is timestamp(0) using this query within the insert statement of course:-select cast (StrDate1 as TIMESTAMP(0)) from table OR select cast ('20090310181010' as TIMESTAMP(0))it says invalid timestamp.Please help

hiRecently one of our client wants to make a selection between teradata and oracle 10g. I our evaluation tells me that oracle 10g is far better than Teradata. But it may be because there are so many persons working on oracle so will anybody here guide me

A SET table force Teradata to check for duplicate rows every time a row is inserted or updated. This can cause a lot of overhead on such operations. Why cant we use multiset tables for all Tables which we are insert by other tables in DWH and use "Group By " to insert rows ?

Hi all,

I tried to using BLC for the first time, but encountered some unusual case.

One of my table cannot be compressed using BLC.

Ferret says "The input table can't be compressed".

why is that? 

Thanks,

Anung

Hi Teradata gurs,

Could you please any body help me how to exceute only integer values in charcater

Suppose i have data like below :

Column A

A123RAJ

RAJ345venkat

Prakash234RAJ

I want to exceute only integer value exclude character value :

Column A

123

345

234

Need help on

how teradata will support for 3rd normal form and dimentional modeling(star & snowflake schema).

and what is the difference between 3 NF and dimentional modeling?

Hi Folks
I am working on putting in place security procedures for a Data Warehouse.
I have come across a very useful article here :-

Hi All,We are trying to setup a teradata server for our dev environment and we would like to replicate the production environment but with only sample data(limited no of records in each table). Needless to say, our dev env has less space compared to teh production.What is the easiest/Industry standard way of doing this? Also, is there any way we can parameterize the no of records from tables in particular database (Ideally, we would like to copy all the data from the process control/metadata tables but only samples from the real data tables)I have heard of the arcmain utility but i am not sure if we can get samples of data from each table in the arcmain dump. Appreciate any help on this!Thanks.

Hi All,I need an SQL Query in TD to modify a column datatype length.something like we do in oracle(say if existing length is varchar(10),i need it to be changed to varchar(20))alter table xxx modify emp_name varchar(20)Thanks for your help,Kumar.