DSXchange

Hahah,this is very very imp req for me,I am struck on this,looking anyone has done in the past the same logic

Hi All, Can you please let me know how to generate multiple recs from a single rec ex: i/p: id,effdate 1,05/01/2011 2,11/01/2011 o/p: id,effdate 1,05/01/2011 1,06/01/2011 1,07/01/2011 1,08/01/2011 1,09/01/2011 1,10/01/2011 1,11/01/2011 1,12/01/2011 1,13/01/2011 2,11/01/2011 2,12/01/2011 2,13/01/2011...

Hi Ray, This job is a big job already developed in Parallel job,
and it is in production,Now I cannot change the design or choice of job,
I need to go with present job,
Can you help in steps

thanks
sai1

Hi Ray,
I am using version 7x I am afraid,I dont have range look up in version 7
thanks sai123

Hi Ray,
I have only one record
id,effdate
1,07/01/2011

the output expecting is

id,effdate
1,07/01/2011
1,08/01/2011
1,09/01/2011
1,10/01/2011
1,11/01/2011
1,12/01/2011

ie till current date,
Is there any way in datastage,to obtain more recs from one rec

thanks in advance Ray,

Hi Ray,
can you pls site an example,bcos,to use a copy stage I have more than 50,000 ids, I cannot substream and later funnel each stream,Pls let me know if my understanding is wrong,
I will be more happy if you can elaborate the answer with a small example
step by step

thanks
sai123

Hi Ray,
Thanks for the prompt reply,
if is seperate into streams,how the date gap will be filled,
for eg:id 1is having dates 5th,6th,and 7th but if my rundate is 12th, then few more recs with dates 8th,9th,10th,11th should be added,any help How this could be done??

thanks

Hi I want to develop a job,with the following req, i/p 3 columns id,date,price 1,05/01/2011,100 1,06/01/2011,200 1,07/01/2011,100 2,06/01/2011,1000 3,12/01/2011,1000 4,10/01/2011,100 4,11/01/2011,200 4,12/01/2011,150 assume my run date is 12/012011, Now there are 3 cases I need to discuss, case 1: r...