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

Answer Posted / sathish

put primary key to target it will reject duplicate rows

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Enterprise data warehouse your projects phase by phase explain?

1444


How can we delete duplicate rows from flat files?

731


What are pre and post-session shell commands?

725


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

995


waht type of interface is used for testing the data in informatica

1825






How can you generate reports in informatica?

566


list out all the transformations which use cache?

676


Why do we need informatica?

548


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

704


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1633


What are the steps involved in the migration from older version to newer version of Informatica Server?

1572


How to elaborate tracing level?

676


What are the different clients of powercenter?

589


Partition, what happens if the specified key range is shorter and longer

2025


What is meant by lookup transformation?

601