Creating hierarchical outbound file
Posted: Wed Nov 24, 2004 10:09 am
Hi,
I have to generate an outbound file with the folllowing hierarchical structure.
This file has Invoice and invoice line item records per Source Application Accronym(SAA).
The structure of the file is:
SAA1
Header1
Invoice 1
Line Item 1
Line Item 2
Line Item 3
Invoice 2
Line Item 1
Line Item 2
Trailer1 9
SAA2
Header2
Invoice 3
Line Item 1
Line Item 2
Line Item 3
Invoice 4
Line Item 1
Line Item 2
Trailer2 9
The header will have a sequence number incremented by 1 for each header record written.
The trailer will have a sequence number incremented by 1 for each triler record written.
It will also have a record count within the header/trailer group.
How can I achieve this in PX?
I have DataStage/PX Version 7.
Can anyone please help?
I have to generate an outbound file with the folllowing hierarchical structure.
This file has Invoice and invoice line item records per Source Application Accronym(SAA).
The structure of the file is:
SAA1
Header1
Invoice 1
Line Item 1
Line Item 2
Line Item 3
Invoice 2
Line Item 1
Line Item 2
Trailer1 9
SAA2
Header2
Invoice 3
Line Item 1
Line Item 2
Line Item 3
Invoice 4
Line Item 1
Line Item 2
Trailer2 9
The header will have a sequence number incremented by 1 for each header record written.
The trailer will have a sequence number incremented by 1 for each triler record written.
It will also have a record count within the header/trailer group.
How can I achieve this in PX?
I have DataStage/PX Version 7.
Can anyone please help?