Hi All,
This is a simple question and I need to figure out the best way. I have input records. For each record I need to process it using almost 20 different kind of procedures. Then need to produce output have sequential number 1 to 20. and same for the next one. So for hundred input records I will get 2000 records having rownum 1 to 2000.
So my question is to know the best way to do it without using any stored procedure and in a single transformer.
Thanks in advance.
Sylvan
create multiple records from a single record.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Wed Apr 12, 2006 12:13 pm
create multiple records from a single record.
sylvan rydes
-
- Participant
- Posts: 47
- Joined: Wed Apr 12, 2006 12:13 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The best solution will have 20 output links. Resize the stage icons so that it doesn't look so messy. Depending on the target, you may not even need a Link Collector; there's no reason that you can't have twenty links feeding independent inserts into a database table. Or even into twenty separate text files, which can be combined subsequently more efficiently than the Link Collector can accomplish.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
yes, you can write a small routine that reads in a record, duplicates it 20 times and cats it together with a LF in between to split it up. Something like
You can enhance it to fit your requirement. But the basic functionality will be the same.
Regards,
Code: Select all
ToDup=trimB(Arg1)
For n = 1 To 20
Ans=:ToDup:char(010):char(013)
Next n
Regards,
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 47
- Joined: Wed Apr 12, 2006 12:13 pm