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
What are the components of datastage?
What is the difference between the local container and shared container?
Highlight the main features of datastage?
How can we improve performance of data stage jobs?
What are the different common services in datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
Name the command line functions to import and export the DS jobs?
What is the difference between account and directory options ?
How to implement complex jobs in data stage?
Can you explain kafka connector?
Lookup constraints
What is the flow of loading data into fact & dimensional tables?
How the ipc stage work?
what is the custome stage in datastage? how can we impliment that one? plz tell me
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?