Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 3 Answers
- 7940 Views
- I also Faced
- E-Mail Answers
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
how do u identify the changed records in operational data?
what is the use of server manager?
What is abap? What are idocs?
Compare ETL & Manual development?
what is pmrep command?
list and discuss two approaches for updation of target table in Informatica and how they are different.
what is an ETL or ETT? And what are the different types?
what are the types in error loging?
can be used COM component in Informatica ?
Difference between flat files and relational sources?
What is cube grouping?
Do we need an etl tool?
Explain the key challenges that you face while performing etl testing.
What are dimensions?
how do u extract data from different data sources explain with an example?
