hw cn v elimate dublicate values from lookup without
overriding sql?

Answer Posted / reddy

hi,
we can eliminate duplicate values by camparision primary key
using lookup

Is This Answer Correct ?    1 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi real timers . iam waiting for ur reply regarding ETL TESTING

1814


Could you explain what is enterprise data warehouse?

563


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

660


What does refresh system mean, and what are its distinctive choice?

573


What is joiner transformation?

589






What is rank index in rank transformation?

615


Global and Local shortcuts. Advantages.

1472


Explain how many types of dimensions are available in informatica?

602


What is xml source qualifier transformation in informatica?

720


Where do we use mapping variables in informatica?

623


What are the conditions needed to improve the performance of informatica aggregator transformation?

587


Explain transaction control transformation in informatica

769


COM components can be used in Informatica

1884


Explain direct and indirect flat file loading (source file type) - informatica

837


What are the advantages of using informatica as an etl tool over teradata?

572