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


Please Help Members By Posting Answers For Below Questions

What is the difference between an operational datastage and a data warehouse?

623


How a source file is populated?

606


what is use of SDR function?

4704


What are the functionalities of link partitioner?

608


What is the difference between datastage and informatica?

606






Give an idea of system variables.

578


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3366


Why do we use link partitioner and link collector in datastage?

677


Difference between sequential file and data set?

635


Why do you need stage variables?

652


What is meta stage?

571


What is the difference between operational data stage (ods) and data warehouse?

665


Nls stands for what in datastage?

722


Why do we use exception activity in Datastage?

705


What is a merge in datastage?

761