If we need to identify different record types within a retailer file , does
Data Stage have a restriction that the identifier used to differentiate between the two records must begin in position 1 for a fixed length file, and also must be a consistent length for all records and for a delimited file, the first field must contain the identifier. Can it be flexible and if so can some one explain as to how?
What the user truly needs is the ability to specify the starting position, length and value of the identifier for each record type For delimited files, the record type shouldnt be limited to the first field.
This topic has been locked.
1 reply Latest Post - 2006-11-22T17:19:25Z by jream
Pinned topic Record Types in Data Stage
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2006-11-22T17:19:25Z at 2006-11-22T17:19:25Z by jream
jream 100000H02U1 PostACCEPTED ANSWER
Re: Record Types in Data Stage2006-11-22T17:19:25Z in response to SystemAdminFor the Multi-format Flat File stage, you can specify various record types. The record ID does not have to be in column 1, but it MUST be in the same column across all record types.
I think you could use the delimited file stage with constraints to break out the various record types, and have more flexibility.