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

Answer Posted / sujatha

in the sq data has to be order by key column..then in the
expression trans we have to create a variable port to hold
the previous records key value...and one more variable port
to compare with the current records key value...if the prev
and curr are equal then the 2nd variable value will
get 'Y',if not equal its value will be 'N'.
Take a router ,process the rows which are having the 2nd
variable value as 'N' to the target....these are unique recs

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the hint? how to use it to reduce the query processing in program?

7176


scenario where i can use only concurrent execution of workflow.

2815


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1944


Name the different lookup cache(s)?

945


what is SDLC way of code development?

1794


lookup transformation with screenshots

3788


Mention a few design and development best practices for informatica?

767


How can we delete duplicate rows from flat files?

995


Under what conditions selecting sorted input in aggregator will still not boost session performance?

855


What are the different versions of informatica?

972


What is the meaning of up gradation of repository?

1630


Mention few power centre client applications with their basic purpose?

747


How to create Target definition for flat files?

996


What is lookup transformation?

841


Is it possible to use a client with different version than that of its Informatica server?

894