source file contains 100 records, i want 10 records in
target file how it possible in datastage
Answer Posted / vamsi
take source --->trf---->trg
in transformer constaints put inrownum <=10
then u can get the required answer.........
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
What are the functionalities of link collector?
Give an idea of system variables.
What are transforms and what is the differenece between routines and transforms?
Differentiate between Join, Merge and Lookup stage?
What are the various kinds of containers available 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
Explain connectivity between datastage with datasources?
what is ds administrator used for?
On which interface you will be working as a developer?
Distinguish between informatica & datastage. Which one would you choose and why?
Can you explain kafka connector?
What are the different types of lookups in datastage?
What is usage analysis in datastage?
Define orabulk and bcp stages?
Highlight the main features of datastage?