Hi all,
I am creating a fixed width output file in a datastage job.
I want to add the header and footer records to the output file
File format:
Header record --->will contain the record type,and source group name
Data record----->actual fixed width data
Footer record--->will contain record type and number of data records
I am doing this by using 3 links in transformer
1 link---header link
2 link---actual data
3 link---footer record
after transformer i am using funnel with sequential option so that i can get the records in the proper order
can you please tell me is there any other method to do this
Thanks for your help
Regards
Swathi S
Adding header and footer records to a output file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 48
- Joined: Fri Feb 29, 2008 1:09 am
- Location: Bangalore
-
- Participant
- Posts: 48
- Joined: Fri Feb 29, 2008 1:09 am
- Location: Bangalore
Hi chulet,
Thanks for your reply.
I am facing problem while creting the footer record.
I have to specify constraints on the header and footer links or else i will get header and footer records as of number of detail records.
for header record i gave the constraint like @inrownum=1 so we will get only 1 header record,but for footer record i am not getting what constraint i have to give.
can any one please help me in this
Thanks for your help
Regards,
Swathi S
Thanks for your reply.
I am facing problem while creting the footer record.
I have to specify constraints on the header and footer links or else i will get header and footer records as of number of detail records.
for header record i gave the constraint like @inrownum=1 so we will get only 1 header record,but for footer record i am not getting what constraint i have to give.
can any one please help me in this
Thanks for your help
Regards,
Swathi S
create a sequence like this
ExecCommand-------LoadJobActivity-----ExecCommand-=---ExecCommand
First echo a header to the filename i.e header>Filename
In Job Activity Stage create a temperory Detail File.
third Stage Move concatenate header file into the header file
fourth stage create a footer record into the above file.
ExecCommand-------LoadJobActivity-----ExecCommand-=---ExecCommand
First echo a header to the filename i.e header>Filename
In Job Activity Stage create a temperory Detail File.
third Stage Move concatenate header file into the header file
fourth stage create a footer record into the above file.
Regards
LakNar
LakNar