We can use the option 'SELECT DISTINCT' in the source qualifier

how will you remove the duplicate records from flat file
without using sorter?

Question Posted / krishnakanthch

Answer Posted / krishnakanthch

We can use the option 'SELECT DISTINCT' in the source
qualifier.

Anybody please tell me whether this works or not.

Is This Answer Correct ?

5 Yes

23 No

Please Help Members By Posting Answers For Below Questions

What is incremental aggregation?

1091

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1583

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1710

how many types of dimensions are available in informatica?

1104

Briefly describe lookup transformation?

1046

According to his methodology what all you need before you build a datawarehouse

1760

What could be the possible resons of locks by user?

1095

What is substr in informatica?

1210

How to implement security measures using repository manager?

1182

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2122

What is persistent lookup cache?

1035

How can one identify whether mapping is correct or not without connecting session?

1453

Explain how many types of dimensions are available in informatica?

1098

What are the different transaction levels available in transaction control transformation?

1210

Can we get 1st record through Informatica(without sequence number).

1479