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
Name the different sorting methods in datastage.
How to reverse the string using unix?
how to implement scd2 in datastage 7.5 with lookup stage
What are the steps needed to create a simple basic datastage job?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How many areas for files does datastage have?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Define Data Stage?
project Steps,hits, Project level HArd things,Solved methods?
What is the difference between operational data stage (ods) and data warehouse?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are stage variables?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is "fatal error/rdbms code 3996" error?
What are transforms and what is the differenece between routines and transforms?
