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


Please Help Members By Posting Answers For Below Questions

How do u convert the columns to rows in datastage?

927


What is staging variable?

850


What is a ds designer?

870


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

571


What are stage variables and constants?

942


Why do we use exception activity in Datastage?

1032


root tree will find which is server job and which is parallel job?

1672


What are routines in datastage? Enlist various types of routines.

879


How do you start developing a datastage project?

873


What is the use of datastage designer?

890


What is difference between server jobs & parallel jobs?

832


If you want to use a same piece of code in different jobs, how will you achieve this?

1070


what is repositery?

1574


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3239


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

1295