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 / subhash
Header: is nothing but Column names/Structure of the table
trailer: is something like FOOTER of the page/file
if file has Header, while reading the file set 'TRUE' for
'First Line is Column names'--
If set true, the first line of a file contains column names on
writing and is ignored on reading.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Differentiate between hash file and sequential file?
How one source columns or rows to be loaded in to two different tables?
What is the difference between datastage and datastage tx?
What are the main differences you have observed between 7.x and 8.x version of datastage?
How do you import and export the datastage jobs?
How to RD using transformer?
What are the stages in datastage?
What is the differentiate between data file and descriptor file?
What is the difference between odbc and drs stage?
How you can fix the truncated data error in datastage?
project Steps,hits, Project level HArd things,Solved methods?
in oracle target stage when we use load option and when we use upsert option?
What is aggtorec restructure operator?
What is orabulk stage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.