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 are the conditions needed to improve the performance of informatica aggregator transformation?

827


What are Dimensional table?

800


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1790


How many types of sessions are there in informatica.please explain them?

935


What is aggregator transformation in informatica?

739


How to generate sequence numbers without using the sequence generator transformation?

879


What is fact table? Explain the different kinds of facts.

801


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

1835


What is aggregate cache in aggregator transformation?

844


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1671


Explain lookup transformation in informatica

832


What is meant by lookup transformation?

805


How many input parameters can exist in an unconnected lookup?

1294


Define the various join types of joiner transformation?

775


What is the difference between writing a joiner query in ANSI style and THETA style?

2141