Genarting n nuber of rows from single row

deva · Post by **deva** » Wed Dec 05, 2007 9:38 am

Hi All,
I have one requirement. I have 3 cols one is cust id,eff.date,no.of.installments.
My question is if custid is 1000 and eff.date is feb/12/2002, and number of installments are 4.
I am looking for the output with 4 rows.
1000 feb/12/2002 4
1000 feb/12/2002 4
1000 feb/12/2002 4
1000 feb/12/2002 4

we are using 7.5 datastage server.

Thanks in advance

prasad111 · Post by **prasad111** » Thu Dec 06, 2007 11:37 pm

Will you be always looking for [if custid is 1000 and eff.date is feb/12/2002, and number of installments are 4] it doesn't make sense.

What you can do it is, Read the incoming data......check the conditions in constraints (have 4 output links) in all the 4 output links check the constraint custid=1000 and date=feb/12/2002 and installment=4 then in the first output link write the output file and the rest three output link append the data........

chulett · Post by **chulett** » Fri Dec 07, 2007 12:11 am

Do you know what the maximum 'number of installments' would be? That answer could drive the solution from 'use X links' to the technique outlined in the FAQ post on creating many rows from one.

ray.wurlod · Post by **ray.wurlod** » Sun Dec 09, 2007 4:16 am

Are you seeking an FAQ on this topic or should you have posted your question in the parallel forum?