Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
Answer Posted / teju
take source sequential file with 1 rec and take target file with 100 records in between use a copy stage to map the source 1 rec to target 100 records.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do u convert the columns to rows in datastage?
What is staging variable?
What is a ds designer?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What are stage variables and constants?
Why do we use exception activity in Datastage?
root tree will find which is server job and which is parallel job?
What are routines in datastage? Enlist various types of routines.
How do you start developing a datastage project?
What is the use of datastage designer?
What is difference between server jobs & parallel jobs?
If you want to use a same piece of code in different jobs, how will you achieve this?
what is repositery?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using 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