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?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between the local container and shared container?
What is datastage?
What are the functionalities of link partitioner and link collector?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the types of views in datastage director?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Difference between server jobs & parallel jobs?
What are sequencers?
Define data aggregation?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How to Remove Duplicate using SQL?
What is a folder? Difference types of stages?
What is the project in datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are data elements?