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 enterprise data warehousing?
What is the different lookup cache(s)?
How many ways are there to do 'remove duplicate records in informatica'?
Explain the etl program with few examples.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Write the unconnected lookup syntax and how to return more than one column.
hi real timers . iam waiting for ur reply regarding ETL TESTING
What differs when we choose the sorted input for aggregator transformation?
How do you load only null records into target? Explain through mapping flow.
How might one distinguish in the case of mapping is right or not without associating session?
What is the difference between Active and Passive transformation?
What does role playing dimension mean?
Define mapping and session?
difference between informatica 8.1.1 and 8.6
How are the sources and targets definitions imported in informatica designer?