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
What is lookup table in etl testing?
what is the difference steps for data modeling?
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
How can we use external procedural logic in informatica?
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?
can cubes contain measures ?
Explain about enterprise scalability and roi of data integration suite?
what make u disappointmnets in u r career
what is Forward,Reverse and Re_engineering?
Mention few test cases and explain them?
What are the types of Data Warehouse applications?
What are the three tiers in etl?
How to fine tune mappings?
what is the difference between cubes and package in cognos
Explain about etl data integration software?