Schema File usage
Posted: Mon Jan 25, 2010 11:50 am
Hello
I have a requirement where i need to read the first record of the input File and parse each and every field and need to map to the target.target being database.The file is semicoln demilited and and every field is enclosed in quotes. This job we are planning to make as common job so even other datastage jobs can use this as a first job.
the problem is our first record can have variable no of fields
since this is a common job we are going to recieve files with different layouts for the first record in the input file.
i.e File1 can have 6 fields in the input file
File2 can have 9 fields in the input file
just wondering how to make this job as common even if the file layout vhanges for the first record of the input file.
I have tried by creating a schema file and enabling runtime col propagation. but since the no of fields are dynamic (just wondering how to create a schema file.
I have a requirement where i need to read the first record of the input File and parse each and every field and need to map to the target.target being database.The file is semicoln demilited and and every field is enclosed in quotes. This job we are planning to make as common job so even other datastage jobs can use this as a first job.
the problem is our first record can have variable no of fields
since this is a common job we are going to recieve files with different layouts for the first record in the input file.
i.e File1 can have 6 fields in the input file
File2 can have 9 fields in the input file
just wondering how to make this job as common even if the file layout vhanges for the first record of the input file.
I have tried by creating a schema file and enabling runtime col propagation. but since the no of fields are dynamic (just wondering how to create a schema file.