how can one eliminate dupliacte data with out using
distinct option?
Answer Posted / ankit kansal
An Alternative way
Using Rank Transformation select group by all and only select only those rows whose indexes are one.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Reusable transformation and shortcut differences
What are active transformations.
Can u generate reports in Informatica?
Can informatica load heterogeneous targets from heterogeneous sources?
What are the popular informatica products?
What is informatica etl tool?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the new features of Power Center 5.0?
How many ways a relational source definition can be updated and what are they?
4 yrs etl devloper roles and responsibilities?any body give solutions
Explain sessions and how many types of sessions are there?
What do you mean by blocking transformation?
When do you use sql override in a lookup transformation?
Quickly characterize reusable change?
How an expression transformation differs from aggregator transformation?