Hi all, can u explain header and trailer records in file? If a file has header

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?

Question Posted / venkatreddy786

3 Answers
12699 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-..

Answer / 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

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-..

Answer / 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

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-..

Answer / sreeni

We can use Read Method:Whether to specify filename:"Path"
Options we can use filter option to remove header & footer
using unix command "sed 1d;$d"

Is This Answer Correct ?

1 Yes

0 No

Post New Answer