Dear all,
I have a requirement.
Input File which is a fixed width file contains 6 fields out of that 4 fields need to be loaded in to target DB(fields which needs to be omitted is 3rd and 5th fileds)
Similarly I will receive another file like above for another feed that loads to same target DB.
In the above scenario how can I use RCP to read source file and omit 2 middle fields and load the rest 4 fields in to target DB.(Please remember file is Fixed width file)
Please help
RCP with Fixed Width File
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 22
- Joined: Thu Jul 05, 2012 5:09 am
- Location: Chennai
RCP with Fixed Width File
Thanks
Nibu Mathew Babu
Nibu Mathew Babu
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why do you feel that you need to use RCP? The perfect solution would not use RCP. To use RCP with a sequential file, you have to go to the trouble of creating a schema file.
You can drop the non-required columns in any intermediate stage in your job design (even a Copy stage, which runs at no cost), or you can use the "drop on input" property for the unneeded columns in the Sequential File stage.
You can drop the non-required columns in any intermediate stage in your job design (even a Copy stage, which runs at no cost), or you can use the "drop on input" property for the unneeded columns in the Sequential File 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.
-
- Premium Member
- Posts: 22
- Joined: Thu Jul 05, 2012 5:09 am
- Location: Chennai