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
Differentiate between Join, Merge and Lookup stage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Describe the main features of datastage?
How do you register plug-ins?
How to read multiple files using a single datastage job if files have the same metadata?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
what is ds administrator used for?
What are iconv and oconv?
Can you filter data in hashed file?
Define project in datastage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Define ds designer?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
