how can one eliminate dupliacte data with out using
distinct option?

Answer Posted / prabha kamaraj

Using Group by command removes all duplicates records in a
table

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1991


If informatica has its scheduler why using third party scheduler?

1015


What is a shortcut and copy in Informatica and how two are different with each other?

939


How to start a workflow using pmcmd command?

940


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

764


Define mapping and session?

786


Is it possible to revert a global repository to local one and why?

867


How can we remove the duplicates from flat file source?

801


How big was your fact table

1507


How to go to the older version for a mapping?

814


What are the performance considerations when working with aggregator transformation?

915


In informatics server which files are created during the session rums?

871


What is the use of an aggregator cache file?

920


What are the main features of Oracle 8i with context to datawarehouse?

1878


How to handle decimal places while importing a flatfile into informatica?

960