Hi This is Vijay, How can your remove the duplicates in sequential File?

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

Hi This is Vijay,

How can your remove the duplicates in sequential File?

Question Posted / vijay

15 Answers
26642 Views
HCL, Scope International, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi This is Vijay, How can your remove the duplicates in sequential File?..

Answer / naga

where you guys find filter option in sequential file

Is This Answer Correct ?

0 Yes

0 No

Hi This is Vijay, How can your remove the duplicates in sequential File?..

Answer / charan

hi this is charan
in sequential file there is no distinct keyword.But we use sequential file properties reject mode=output and then use remove duplicate stage based on key column(here we can't store the duplicate records).

Is This Answer Correct ?

0 Yes

0 No

Hi This is Vijay, How can your remove the duplicates in sequential File?..

Answer / kiran

Hai Venugopal..,

This is kiran............

I tryied but im not getting proper result...please try
again please intimate me.........

Thanks you...................

Is This Answer Correct ?

1 Yes

2 No

Hi This is Vijay, How can your remove the duplicates in sequential File?..

Answer / manoj

By using "DISTINCT" key word can remove all the duplicates
in the record or file .......

Is This Answer Correct ?

1 Yes

3 No

Hi This is Vijay, How can your remove the duplicates in sequential File?..

Answer / venugopal

Hi Vijay it's simple

In the source sequential file goto Output->Properties
under options you mention reject mode = Output.

This will gives the duplicate records in the output.

This will 100% work why because in my present project we
are using the same format.

Is This Answer Correct ?

3 Yes

10 No

Post New Answer