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
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are Dimensional table?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How many types of sessions are there in informatica.please explain them?
What is aggregator transformation in informatica?
How to generate sequence numbers without using the sequence generator transformation?
What is fact table? Explain the different kinds of facts.
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is aggregate cache in aggregator transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Explain lookup transformation in informatica
What is meant by lookup transformation?
How many input parameters can exist in an unconnected lookup?
Define the various join types of joiner transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?