Hi ,
for a data load ,i get two files source file with different format . how can i make my job generic to read the source files with has format diffrence .can some one help out to acheive this by schema file option.
Thanks in Advance
Reg Schema file
Moderators: chulett, rschirm, roy
Reg Schema file
thanks n regards
nani
nani
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Reg Schema file
nani0907 wrote:Hi ,
for a data load ,i get two files source file with different format . how can i make my job generic to read the source files with has format diffrence .can some one help out to acheive this by schema file option.
Thanks in Advance
If you have file Identifier then you can make generic. Based on the file identifier you can create two data flows.
Sivakumar
As Ray suggests, reading 2 different file types is quite easy with schema files, what is possibly more important is how you intend to use the data. Ie do you want to load into a database, a dataset, or another file. What is the format of the target - is this also 2 different schema?
Without answers to questions like these it is very difficult to suggest a suitable course of action.
Without answers to questions like these it is very difficult to suggest a suitable course of action.
So you will have to create a schema for each file that you wish to read.
You can apply this schema on the sequential file stage with RCP on and load the data directly into a dataset. Keep in mind that you will have to parameterise file and dataset names, as well as the schema names, and call these accordingly from your sequence.
You can apply this schema on the sequential file stage with RCP on and load the data directly into a dataset. Keep in mind that you will have to parameterise file and dataset names, as well as the schema names, and call these accordingly from your sequence.