![Evil or Very Mad :evil:](./images/smilies/icon_evil.gif)
I am five tab delimited files(same meta data), i want to app
Moderators: chulett, rschirm, roy
I am five tab delimited files(same meta data), i want to app
I am five tab delimited files(same meta data), i want to append them in single oracle table.In wat way i can append. ![Evil or Very Mad :evil:](./images/smilies/icon_evil.gif)
![Evil or Very Mad :evil:](./images/smilies/icon_evil.gif)
thanks & regards
kk
kk
Re: I am five tab delimited files(same meta data), i want to
job design as below.
take all of your five input input files ----> Transformer--->hash file(or sequential file if you want to maintain duplicate records)-->OCI stage (Insert rows without clearing).
hope this design may help.
2nd design:
may folder stage also help.
take all of your five input input files ----> Transformer--->hash file(or sequential file if you want to maintain duplicate records)-->OCI stage (Insert rows without clearing).
hope this design may help.
2nd design:
may folder stage also help.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use a Sequential File stage. Set it to use a Filter command. Use type or copy as the filter command.
DataStage reads the output of the filter command.
Code: Select all
type file1 file2 file3 file4 file5
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Sure is. Sequential File stage, either with a Filter command as indicated, or with five output links.
And that's just with server jobs. In parallel jobs there are even more options, for example a single Sequential File stage reading using multiple File property values or a wildcard, using parallel processes.
Code: Select all
-------------->
Seq --------------> Oracle
File --------------> OCI
stage --------------> stage
-------------->
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.