Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / subbuchamala
-->If the Source is File:
"Read First Rows"=10000 --> Only read the first specified number of rows from each file.
"Filter"= sed -n '1,10000 P' or head -10000: we can use UNIX commands to filter the data.
-->If source is DB:
Oracle: where rownum<=10000
DB2: sample 10000 row only
Teradata: fetch first 10000 rows only
-->In Transformer:
We can use @INROWNUM<=10000 system variable
We can use Stage variables and count the values and in the contraints part use Stage_Var<=10000
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain Quality stage?
What is the difference between informatica and datastage?
On which interface you will be working as a developer?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What is the difference between datastage and informatica?
What are system variables and sequencers in datastage
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Can you implement SCD2 using join, transformer and funnel stage?
What is apt_config in datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How do you remove duplicate values in datastage?
What are the difference types of stages?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is the difference between server job and parallel jobs?
How to reverse the string using SQL?
