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
What are the key benefits of ETL Testing?
What are the etl testing operations includes?
What are snapshots?
where is the cache (lookup, index) created and how can you see it.
What is a lookup table in etl?
Define Dynamic push down optmization?
Explain the key challenges that you face while performing etl testing.
what are the production issues in datastage?
Two default user groups created in the repository are____and_____.
how do u really know that paging to disk is happening while u are using a lookup transform?
what is pmrep command?
What is abap? What are idocs?
how do use session mapping parameters ?(in which transformation)
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?
Difference between flat files and relational sources?