Eliminating of duplicate records without using dynamic lookups
Answer Posted / bhagya
1) By enabling the option in sorter transformation as
select distinct
(or)
2) By enabling all the values as group by in aggreagator
transformation
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to delete data which is not in source table?
what is the use of server manager?
What is Data Vault???
explain the methodology of Data Warehousing?(Polaries)
What are the various tools used in etl?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
What is partitioning? Explain different types of partitioning?
What is the difference between round-robin partitioning and hash partitioning?
What are the different Lookup methods used in Informatica?
What are materialized views & where do we use them?
Explain the difference between etl tool and olap tools?
how many maximum session supports to multiload in teradata ??
where is the cache (lookup, index) created and how can you see it.
what is pmrep command?
how do u extract data from different data sources explain with an example?