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
- 12307 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 are the processing stages?
What could be a data source system?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is ds designer?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
CHANGE CAPTURE
How rejected rows are managed in datastage?
Define APT_CONFIG in Datastage?
What is a datastage job?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How to Remove Duplicate using SQL?
What are the types of jobs we have in datastage?
root tree will find which is server job and which is parallel job?
What are the differences between datastage and informatica?
How do you run datastage job from the command line?
