write a query for how to eliminate the duplicate rows
without using distinct?

Answer Posted / abhishek kumar

select id from tgt_table group by id;

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how many types of dimensions are available in informatica?

595


What's the layout of parameter file (what does a parameter file contain?)?

1917


What is a transaction control transformation?

768


What is different between the data warehouse and data mart?

630


In informatica workflow manager, how many repositories can be created?

782






Write the advantages of partitioning a session?

745


How do you set a varible in incremental aggregation

1449


What does reusable transformation mean?

676


Is it possible to create multiple domains on a single Informatica server?

754


What is exclusive and normal mode for repository services?

713


Explain the etl program with few examples.

548


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

1809


Explain what are the different types of transformation available in informatica.

573


in reporting we add some new objects,how we get the count of the newly added objects to the report

1753


Why update strategy and union transformations are active?

593