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
- 12338 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
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
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is staging variable?
What are the different kinds of views available in a datastage director?
Can you explain tagbatch restructure operator?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How many types of hash files are there?
Explain ibm infosphere information server and highlight its main features?
State the difference between an operational datastage and a data warehouse?
Explain Quality stage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Enlist various types of routines in datastage.
What are the different layers in the information server architecture?
What is the difference between Datastage 7.5 and 7.0?
What is the roundrobin collector?
