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
Can you explain engine tier in information server?
What is the difference between validated and compiled in the datastage?
Is the value of staging variable stored temporarily or permanently?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the types of jobs we have in datastage?
Can you explain kafka connector?
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 is a ds designer?
How to read multiple files using a single datastage job if files have the same metadata?
What is job control?
Explain connectivity between datastage with datasources?
Explain how a source file is populated?
What is the difference between datastage and datastage tx?
What is the difference between the local container and shared container?
What are datastage sequences?
