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
What are the different type of jobs in datastage?
What is the difference between passive stage and active stage?
What are constraints and derivations?
How do you import and export the datastage jobs?
Describe the architecture of datastage?
How many types of sorting methods are available in datastage?
What are the features of datastage flow designer?
What is a quality stage in datastage tool?
Why fact table is in normal form?
How to reverse the string using SQL?
What is the difference between server job and parallel jobs?
How do you run datastage job from the command line?
How many types of views are there in a datastage director?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How to perform incremental load in datastage?