Eliminating of duplicate records without using dynamic lookups

Answer Posted / kal_leo@hotmail.com

Hi U can eliminate duplicate records by an simple oneline
SQL Query.

select id, count(*) from seq1 group by id having
count(*)>1;

U can run this query directly on any SQL*Plus or U can
override SQL in any transformation.

Hope this is of any help.

Kal

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is lookup table in etl testing?

966


what is the difference steps for data modeling?

2319


how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2336


How can we use external procedural logic in informatica?

743


Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1679


can cubes contain measures ?

1848


Explain about enterprise scalability and roi of data integration suite?

685


what make u disappointmnets in u r career

1995


what is Forward,Reverse and Re_engineering?

2006


Mention few test cases and explain them?

732


What are the types of Data Warehouse applications?

742


What are the three tiers in etl?

815


How to fine tune mappings?

743


what is the difference between cubes and package in cognos

4759


Explain about etl data integration software?

682