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
What all the types of jobs you developed?
What are the functionalities of link partitioner?
Differentiate between datastage and informatica?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
AGGREGATOR default datatype
What are transforms and what is the differenece between routines and transforms?
How can you write parallel routines in datastage PX?
What is the purpose of pivot stage?
Does datastage support slowly changing dimensions ?
why do u need the IOS upgradation in a FC switch
If you want to use the same piece of code in different jobs, how will you achieve it?
what is the difference between == and eq in UNIX shell scripting?
Define meta stage?
Differentiate between operational datastage (ods) and data warehouse?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
