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


Please Help Members By Posting Answers For Below Questions

What are the key benefits of ETL Testing?

753


What are the etl testing operations includes?

806


What are snapshots?

753


where is the cache (lookup, index) created and how can you see it.

1776


What is a lookup table in etl?

854


Define Dynamic push down optmization?

2076


Explain the key challenges that you face while performing etl testing.

761


what are the production issues in datastage?

9994


Two default user groups created in the repository are____and_____.

1819


how do u really know that paging to disk is happening while u are using a lookup transform?

1742


what is pmrep command?

2137


What is abap? What are idocs?

698


how do use session mapping parameters ?(in which transformation)

1655


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?

1936


Difference between flat files and relational sources?

1990