source file contains 100 records, i want 10 records in
target file how it possible in datastage

Answer Posted / alok

At source stage properties (I'm assuming Sequential File Stage is used), go to the Filter option in properties tab and type head -10. The sq file stage will read only top 10 records and ignore the rest.

Is This Answer Correct ?    11 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different kinds of views available in a datastage director?

599


What are the types of containers and how to create them?

556


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2027


Can you explain how could anyone drop the index before loading the data in target in datastage?

890


What are the components of ascential data stage?

647






Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1757


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

1445


What are sequencers?

616


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1133


How you can fix the truncated data error in datastage?

1191


what is ds administrator used for?

719


Differentiate between Join, Merge and Lookup stage?

644


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2007


What all are the different way to run a job?

639


client know skid info?

1631