DSXchange

Any one help on this please

Include the below code in transformation stage.
svSeqNum=@inrownum*2

For 1st record it will be 2
2nd row 4
3rd row 6

This is applicable to above data. You can change little as per your requirement

I need to generate the output as mentioned in the early post. Initially I am doing couple of stages to get the dataset. After there is a table which contains the detail information about the ids and date. Now when ever I take Id and date from the dataset. I will do lookup, join ...... The check must...

Hi Expert, I am unable to achieve below scenario. Dataset contains( This is Driver dataset) Id Date ---- -------------- 1 01-01-10 1 04-02-10 1 06-05-10 1 10-06-10 Table is contining below data Id Date Name ---- -------------- ------------ 1 01-01-10 Rick 1 05-02-10 Symon 1 05-05-10 Roger 1 10-06-10...

chulett wrote:a) You can't change a job parameter value.
b) Why not just script this using split? Don't need to job for that.

Thanks for quick response. I got your point but I want to achieve this from DS job. Please suggest, how can I split

Hi Experts, I am new to Datastage Development. I have a requirement to create multiple files from a single big file. I am planning to do as below. 1000(This will change everyday, may be next day 15k records come) records file is there. I need to create dataset of 250 records each. Job parameter pRec...