Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 12692 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
I have a few records all are same structures data, I want to store data in multiple targets how?
What is ibm datastage flow designer?
can we half project in parallel jobs and half project in server jobs?
what is mapping lookup
If you want to use the same piece of code in different jobs, how will you achieve it?
How to lode data in sequntional files perform faster?
why do we need a datawarehouse when we have databases to store data?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is merge stage?
hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
what is ds administrator used for?
Teradata 
