I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
Answers were Sorted based on User's Feedback
Answer / subbuchamala
SeqFile---->Tranfrmr----->TGT
in Seq file we can add 'ROW NUMBER COlumn' as ROW_NUM which will numbers to each row.
we add 2 parameters to the job: RowNum1, RowNum2
in transformer, in the constrain we can specify below condition:
ROW_NUM<>RowNum1 OR ROW_NUM<>RowNum2
then we can skip those two records.
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / subhash (subbuchamala)
If we use @INROWNUM, then we have to run transformer on 'single' NODE.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / ankit gosain
Hi,
You can block any specified record(s) from the source seq.
file with the help of a Transformer Stage.
Source Seq. File ----> Transformer ---->Target Seq. File
Now, in Transformer stage create a Stage Variable (say
row_num) & initialize it with ZERO.
In it's derivation, just increment it by ONE (i.e.
row_num+1)
Now, Insert a new column in the output & it's derivation,
assign the variable (row_num).
Now, in the contraint tab wirte row_num<>10 OR row_num<>11
If you have some other doubts or queries, you can mail me
on ankitgosain@gmail.com
Cheers,
Ankit :)
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / srinivas
We can do it by using filter option in sequencial file by using sed command
sed '10d;11d' filename then you will get required output
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Wat is pre-load in Hashed file
Difference between sequential file and data set?
In one project how many shared containers are created?
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
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me
How can one find bugs in job sequence?
how to delete one row in target dataset
Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.
i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?
I have a few records just I want to store data in to targets cycling way how?
In which situations we can use normal and sparse lookup stages