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 / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to reverse the string using unix?

2793


What are the types of jobs we have in datastage?

663


What are system variables and sequencers in datastage

602


What is process model?

1547


Define data aggregation?

660






Explain usage analysis in datastage?

644


What are the types of views in datastage director?

1240


Can we use target hash file as a lookup ?

2808


On which interface you will be working as a developer?

629


i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3309


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1461


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

1799


What is a merge?

663


How to read multiple files using a single datastage job if files have the same metadata?

729


How to perform incremental load in datastage?

659