source is sequential file.
Requirement:
Input file's data should be distributed like 1st 3 row in file1, next 3 row in file2, next 3 rows in file3 again next 3 rows in file1 and continues.
Currently we have less records in source so i generated rownum in sequential filestage and put
constraint in transformer which is not good practise.Without hardcoding constraints in transformer is there any way to do it.
sequential file clarification
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Slower (because of spurious requirement for sequential mode) and less efficient (because of additional CPU cycles for calculation) than the Mod() function already suggested.
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.