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
26753 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 / kiran

Hi All,

Good Day...............!

Go to Sequential File ---> Select Filter Property ----->
Set Filetr = sort | Uniq......

Now its Working properly......

if u have any doubts pls make me a call 8055902709

Is This Answer Correct ?

23 Yes

0 No

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

Answer / rajesh

Go to Sequential File and then Select Filter Property
Set Filter = sort|uniq...........

Is This Answer Correct ?

6 Yes

0 No

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

Answer / vijay

Hi Kiran My Question is Correct.

How can u remove the duplicate in source file( in
Sequential file stage)?

Is This Answer Correct ?

8 Yes

3 No

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

Answer / prasu

Hi Manoj,

Where u will give the Distinct Keyword...This is not a
table ..it is file...

Is This Answer Correct ?

5 Yes

0 No

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

Answer / sravanthi reddy

Hi this is sravanthi. if u click the options in the right
side bottom u will find filter option

Is This Answer Correct ?

8 Yes

3 No

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

Answer / kiran

Hai vijay.., ur query nt proper.seq is sourcd or
target.just say.i wil give proper ans

Is This Answer Correct ?

9 Yes

5 No

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

Answer / arun

Sort the incoming data using a sort stage & use remove
duplicates on the key columns. This will remove the
duplicates in ur source file.

Is This Answer Correct ?

5 Yes

3 No

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

Answer / chowdary

in sequntial file options filter--> sort | uniq -d
this will give best performence to remove duplicates.

Is This Answer Correct ?

1 Yes

0 No

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

Answer / sabariesh

Hi Sravanthi, if i have any more doubts how i can i contact
you..?

Is This Answer Correct ?

1 Yes

0 No

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

Answer / chinky

where can we select filter property in sequential file?

Is This Answer Correct ?

1 Yes

1 No

Post New Answer