How to eliminate duplicates from flat file..what is the
procedure
Answer Posted / ram
one more answer is ....
use an aggeregator transformation and select all ports
as 'group by'...then u will get distinct records...
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How does a rank transform differ from aggregator transform functions max and min?
How to configure mapping in informatica?
What are the components of Informatica? And what is the purpose of each?
What are the main features of Oracle 8i with context to datawarehouse?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
update strategy transformation in informatica
What is exclusive and normal mode for repository services?
What are the different types of transformation available in informatica.
What are multi-group transformations?
How do you use reject loader.
What is the scenario which compels informatica server to reject files?
How might one distinguish in the case of mapping is right or not without associating session?
write a query to retrieve the latest records from the table sorted by version(scd)
Suppose we do not group by on any ports of the aggregator what will be the output?