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


Please Help Members By Posting Answers For Below Questions

What are data elements?

647


Define ds designer?

758


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1608


How complex jobs are implemented in datstage to improve performance?

584


Is it possible to query a hash file?

1552






tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2694


What are the benefits of datastage?

716


Name the different types of Lookups in Datastage?

718


explain about citrix scheduling tool in datastage

1803


What is data partitioning?

736


What are system variables and sequencers in datastage

598


What is difference between symmetric multiprocessing and massive parallel processing?

645


What are iconv and oconv?

761


What is the difference between datastage and datastage tx?

583


Distinguish between informatica & datastage. Which one would you choose and why?

574