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 |
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
What is the Difference Between DataStage 7.5 version and 8.1 Version?
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel
how to closeing records after 10,000 records come?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
explain about citrix scheduling tool in datastage
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
what is operator combinality 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 are the errors,warnings in datastage
What are the unit test cases you used in your project?