I have Seq file, I don't want 10, 11th(or any two records like 20, 30th rec

Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

Question Posted / subbuchamala

6 Answers
12556 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in th..

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

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in th..

Answer / subhash (subbuchamala)

If we use @INROWNUM, then we have to run transformer on 'single' NODE.

Is This Answer Correct ?

8 Yes

0 No

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in th..

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

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in th..

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

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in th..

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

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in th..

Answer / sharath

Yes Mr Ankit Gosian Answer is correct. But What if numbers
are 1 4 7 9 10 11 13 and so on then.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer