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
Genarting n nuber of rows from single row
Moderators: chulett, rschirm, roy
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........
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........
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: