how can one eliminate dupliacte data with out using
distinct option?
- 5 Answers
- 9530 Views
- Patni, Wipro, I also Faced
- E-Mail Answers
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 different types of repositories created using informatica?
What is the difference between informatics 7x and 8x and what is latest version?
Mention few advantages of router transformation over filter transformation.
What is xml source qualifier transformation in informatica?
Differentiate between Load Manager and DTM?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Differentiate between a repository server and a powerhouse?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the sequence generator transformation in informatica?
What are the differences between source qualifier and joiner transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Why union transformation is an active transformation?
What is the benefit of session partitioning?
What does cheating measurement mean?
What all join we can perform in LOOKUP transformation?
