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 is the hint? how to use it to reduce the query processing in program?
scenario where i can use only concurrent execution of workflow.
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?
Name the different lookup cache(s)?
what is SDLC way of code development?
lookup transformation with screenshots
Mention a few design and development best practices for informatica?
How can we delete duplicate rows from flat files?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the different versions of informatica?
What is the meaning of up gradation of repository?
Mention few power centre client applications with their basic purpose?
How to create Target definition for flat files?
What is lookup transformation?
Is it possible to use a client with different version than that of its Informatica server?