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

Answer Posted / sathish

use aggregater T/R after source qualifier select all ports in group by clause it will removes the duplicates

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

tell me about your project functionality

1329


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

95


How to configure mapping in informatica?

94


What is the status code in stored procedure transformation?

119


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

976






Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1263


How do you use reject loader.

1362


What are the restrictions of union transformation?

90


What are the different ways to implement parallel processing in informatica?

103


How to Create a folder using pmrep command?

99


What is different between the data warehouse and data mart?

119


In which scenario did u used Mapping variable?

1028


What are Dimensional table?

124


Explian the connected and unconnected lookup transformation

113


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1138