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
Differentiate between datastage and informatica?
What are the primary usages of datastage tool?
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.
Define Data Stage?
What is the difference between odbc and drs stage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Can you explain link buffering?
What is difference between join, merge and lookup stage?
What is the different type of jobs in datastage?
Define Job control?
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)
What is a folder? Difference types of stages?
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
What are the areas of application?
What is the precedence of stage variables,derivations, and constraints?