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
what is the complex transformation you used in informatica
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How can we improve session performance in aggregator transformation?
How do you handle two sessions in Informatica
Explain the types of transformations?
how to load dimension table and fact table. plz tell me the steps.
What is an aggregator transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Explain in detail about scd type 1 through mapping.
What are the types of data warehouses?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Differences between connected and unconnected lookup?
what is SDLC way of code development?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How to load a Dimension ? and how to load a fact table?