DSXchange

Hi MY JOB IS GETTING ABORTED IN BETWEEN AND GETTING FOLLOWING ERROR , I KNOW THIS TOPIC IS DISCUSS IN THIS FORUM AND THERE MIGHT BE AN NULL VALUE IN ANY OF THE KEY COLUMN , BUT IS THERE ANY WAY THAT I WILL GET THE NAME OF COLUMN AND EXACT FILE FROM WHERE NULL IS COMING DataStage Job 133 Phantom 3296...

hi how can in i improve the performance while fetching the data from oracle , using ODBC stage. in input i m having 13 lacks rows , and looking for a speed near to 1000 rows/ sec. if i attempt to view the data i am getting error that metadata mismatch and followed by an 'data source empty' message ,...

Thanks Anupam, for the solution. I am looking for the difference in dates , say 12/31/2002 6:00:00 PM and 12/31/2002 6:00:00 PM and 19/31/2002 6:30:00 AM where both r having datatype as timestamp and target is having datatype as NUMBER (here difference will be in MInutes) Can u plz give the Solution...

With source as oracle and target as oracle , i am not able to pass the date , its going NULL in the target,

ALSO with INPUT as 12/18/2001 10:10:44 PM and 12/18/2001 10:10:54 PM , how to get the difference in days or in minites.

Thanks to all of you for your valuable suggestion. My problem got resolved, I have used one routine to read the source & take only the time part.
Thanks,
Bhaskar

Hi, I am trying to extract time part from a column whose data type is Date. For example my sample data is "1/1/1970 10:31:00 PM" and I want to take only "10:31:00 PM". My source table column is Date & target table column is also Date. I have tried it with DSTransform (TIMESTA...