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
- 12535 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 |
Explain the situation where you have applied SCD in your project?
What is the difference between in process and inter process?
What are stage variables, derivations and constants?
How many input links can you give to a Transformer stage?
How to perform incremental load in datastage?
How to convert table data into xml file using xml output stage? please explain step by step;
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
What all are the different way to run a job?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What is usage analysis in datastage?
why dataset ?
Teradata 
