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?
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 |
What are the types of views in datastage director?
how to remove duplicates in transformer stage by using stage variables?one example?
What is exact difference between Parallel Jobs and server Jobs..
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
What are the components of datastage?
what is the difference between 7.1,7.5.2,8.1 versions in datastage?
Tell me Wt main advantage of Stage varibles? Project level hints?
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance
What are the types of jobs we have in datastage?
What are stage variables and constants?
I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know