DSXchange

Hi :lol: I have files in my inbound directory as whs_ e1 _20100502.txt, whs_ e2 _20100502.txt, whs_ e3 _20100502.txt. dates are changing for every day load. Now I have to generate the row numbers for each and every file. For example if first file contains 100 records, numbers will be generated in a ...

Is the data loaded into target database. Try the following things , if not works any of the following .Think about the patches 1.The warning is mainly related to casting error. Means the datatype mismatch from Oracle to Sql server database. 2.If you used two stages in your job oracle enterprise stag...

Hi,

You are reading csv file by using which stage.Please mention these details.

I have one option for solution
Are you using same dataset name in two different jobs.

And already you loaded into one sequential file whose name as exaclty like what you mentioned in dataset like name.ds and you are giving same name in dataset now
Thanks

Can you please eloborate the problem definition
In the example you specified the output which you need is not clearly mentioned and why without running the transformer in sequentail..?

I think in datastage filter stage, you can use sql where clause conditions, these conditions are same in any flavour

Thanks a lot abhi jain
the solution which you gave is useful for my project now

Yes prefix statements must be removed

I used schema files in my project, after creating schema files we removed prefixes, it does not failure any scenarios, no problem , please remove those prefix statements.
thanks

I used sql statement as a parameter in oracle stage. that sql itself is parameterized in its where clause. job is aborted and it is giving error like fatal error Non-pipe (or non-virtual data set) with .v in its name For example my query is select * from table where column1 = to_date( parameter1,'YY...

Hi :oops: Check first job1 has finished successfully,if it has not finished successfully, then dataset will give error for rest of the jobs, even though it already created for previous runs.if the job is successfull then see whether that is created at some other lcoation, at last go to firstjob manu...

Hi
are you using any function in the jobs earlier before migrating
and now after migration , that function goes wrong,
create one sample job which will contains date fields and check for various formats and change your job according to that

:oops: Hi Sorting data before sending to lookup/merge/join/cdc stages is necessary why means for lookup no need to sort the data for join not mandatory but improves performance for merge its compulsory to sort before sending to it,it itself has a default sort link,merge sends reference tables data t...

:oops: Hi as you said the file has a Tab delimiter then the sequential file in datastage extracts the data from the file, if any value in file contains null then use this funtion to handle null values in transformer, if your aim is to replace null with 'unknown' then use this funtion If IsNull(Colum...

Thanks For Suggestion
next time before posting i will take care of my words