DSXchange

hi srinivas,
Thanks for your reply.
The source and the target is oracle.When I imported the table defintion the number data type became decimal in datastage tabledefinition.

.pls help me in this issue

Hi all, I am testing the data against production .In production the data is loaded using a oracle stored procedure and in the development the data is loaded using datastage 7.1. The problem is the data in production has data like this -0.01 and in the development it shows as 0.I have tried increasin...

Hi all,
Thanks for ur replies.I have tried all your solutions It is still giving the same problem.Can you please change the code how it should be.My routine name is max ,sainath.

Thanks

Hi all, I have written a routine which fetches the data from text file and passes that value as a parameter to the job.I have called the routine in a routine activity and passed that result to the job as parameter like this routine_stagename$returnvalue. the routine code is OpenSeq Filepath To FileV...

Hi sainath, my data was like this aaaaa,bbbbbb with two columns only but many records.when i tried to open the coloumn it gave me an error .but when i used MaheshKumar Sugunaraj solution it got solved. But one of friend has got the same problem i have tried MaheshKumar Sugunaraj solution he is not g...

Hi luk,
Instead of going parameters for 50 jobs why cant you use environmental variables which is a good solution for your requirement.

Thanks everyone for the response,
MaheshKumar Sugunaraj solution has worked out.

thanks

Hi,
Thanks for the reply.I have used | as the delimiter and this is not working out.comments apperciated

Hi all, i am using a sequential file to extract data from a text file which uses a delimiter to seperate the data.I am getting the error below.To my knowledge all the settings are right,but still i am facing this issue.Can anyone guide me. TIMEDETAIL_SRC..Sequential_File_0.DSLink3: nls_read_delimite...

Hi all,
we have simplejob with a oci--xfm--oci which calls a before sql procedure.the job hangs when it calls that procedure.I have tried all the ways for running the job everything went waste.is there any way to investigate the mapping why it is hanging
thanks in advance.

hi all, I have a requirement to write a routine to capture the number of rows processed per second at the target link. For eg: oci _src----xfm----oci_tgt . If a mapping is like the above given mapping I want to capture the no. of rows processed at the oci_tgt link with rows per second details using ...