Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 3 Answers
- 7661 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
what is session partitioning?
how do u set partition points in the mapping?
What is tracing level?
what do u do when DB time takes more?in sap bi
What are the steps involved in etl process?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is an ETL or ETT? And what are the different types?
how do use session mapping parameters ?(in which transformation)
Can we create Hierarchies in generic datasources?
What is data cleaning?
what are the types in error loging?
what are the reports developed in sap bw project and what is the requirement for developing it?
How to delete data which is not in source table?
what are the production issues in datastage?
What are your responsibilities as an etl tester?
