Interested to Buy Any Domain ? << Click Here >> for more details...
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
- 6 Answers
- 12217 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sushil
SeqFile---->Tranfrmr----->TGT
To number of rows in a sequential file in Transformer we
can use @INROWNUM, store value in variable ROW_NUM and then
by providing condition as same condition as:
ROW_NUM = '10' and ROW_NUM = '11' we can skip such records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between symmetric multiprocessing and massive parallel processing?
CHANGE CAPTURE
Describe routines in datastage? Enlist various types of routines.
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Describe link sort?
Differentiate between validated and Compiled in the Datastage?
What is the difference between passive stage and active stage?
what is flow of project?
How we can covert server job to a parallel job?
How many types of sorting methods are available in datastage?
How and where you used hash file?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is the differentiate between data file and descriptor file?
Difference between sequential file and data set?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
