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
- 12591 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 |
how many datamarts we will use in real time project and when will use the datamart?pls send the replay early
What are the partition techniques available in your last project?
How one source columns or rows to be loaded in to two different tables?
What is difference between join, merge and lookup stage?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
Name the different types of Lookups in Datastage?
i have the source from Uk,north america how can i pass the data two tables based on the locations
what is executable in DataStage?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
which unix commands mostly used in datastage
Teradata 
