DSXchange

How to use it? any idea? just run the DataStageBackup.bat file??

Please verify the log under 'Scratch' folder in unix, there may be some data issue.
some times the fields may come with invalid data or invalid data type,so while inserting it may create a problem

If not sit with your DBA and ask them to give stats while loading..

--Arvind

-------------- Now I got the problem resolved Not either from the DataStage side or from Oracle side this is network card issue, there were lot of collissions between DataStage server and Oracle sever, because the network speed was set to very low . Now the unix guys increased the network speed to t...

Hi Friends, Greetings This is a PX environment I am facing performance issue while inserting 2,800,000 rows from a dataset to Oracle table using Oracle OCI Bulk stage The job design is as follows dataset--->copy stage----> OraOCI Bulk stage It is taking 2 hours to insert nearly 3 million records I h...

Hi All, Here is the job design Seq_file----->Pivot stage----->Transformer----->Oracle_table I am taking data from Seq file and transform and sending to Oracle_table There are some fields from cobol copy book which occurs twice in the source and getting populated as Column_A,Col_B,Col_C, FLAG,Col_B_2...

But, what is even more concerning is, when the data type is Decimal (15,4), Decimal (38,5) etc.

Ans: For Decimal ( 15,4) , you can give the Null field length as length+scale i.e. 15+4 = 19

Hi All, I need best practice suggestion for the following design I designed the job in following way (Staging Database) ODBC stage----->Transform------>(Target Database )ODBC stage I was told that connecting to two databases from one job is not a good practice.... is this a good practice? what will ...

Hi All, I want to convert the date format of the type 'yyyyjjj' ex:2006346 to date. and i am trying to do it by using the julianday to date function. but it's not working . The format of the output date is 'yyyy/mm/dd'. how to convert this . Any help is appreciated. syam. Hi Syam, Actually, the dat...

Thanks for your reply I guess the date is Ordinal date. example:2005191 Even though the job is developed in Parallel, I used Basic Transformer to use these DateGenericGetYear,DateGenericGetMonth and DateGenericGetDay functions. I am getting this ordinal date with datatype as decimal(7).I want to con...

I am trying to convert julian date format to a target field which is in datetime datatype in sqlserver. I tried by using DateGenericGetDate function, but in transformer help it was given that the output will be in string format.But, I am looking to get the output as datetime data type. Thanks in adv...