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


Please Help Members By Posting Answers For Below Questions

Differentiate between datastage and informatica?

729


What are the primary usages of datastage tool?

627


1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3505


Define Data Stage?

647


What is the difference between odbc and drs stage?

645






WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3273


Can you explain link buffering?

731


What is difference between join, merge and lookup stage?

642


What is the different type of jobs in datastage?

581


Define Job control?

681


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2326


What is a folder? Difference types of stages?

636


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2277


What are the areas of application?

664


What is the precedence of stage variables,derivations, and constraints?

604