Hi all, can u explain header and trailer records in file?
If a file has header and trailer /master-detail records how
will you read it in datastage?
Answer Posted / datastage4you
Whenever there is any header and footer with file, those must identifiable like First line will be header or last line will be footer or by some column info (row type)
so if data follows first criteria, use unix or datastage head and tail to extract those
thanks
www.datagenx.net
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can you define merge?
What is the difference between hashfile and sequential file?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are the benefits of datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
how to run a sequential file stage in parallel if the stage is used on the TARGET side
How to manage date conversion in Datastage?
What are the types of hashed files in data stage
What is aggtorec restructure operator?
Terminate Activity
Differentiate between data file and descriptor file?
How and where you used hash file?
What are the components of ascential data stage?
What is a quality stage in datastage tool?
What is a ds designer?