In a table there are 1 million records there in which 3
records are duplicate how will you find out those 3 records?
Answer Posted / teja_dwh
use this query u will get this.For example i am taking emp
table
select * from emp where rowid not in(select max(rowid) from
emp group by empno)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the types of lookup transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Why update strategy and union transformations are active?
What is transformation?
What is a node in Informatica?
Explain the code page compatibility?
What are the types of presistent cache in look up tr.
Explain how to import oracle sequence into informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Reusable transformation and shortcut differences
What is the use of code page?
What is a passive transformation?
Briefly define reusable transformation?
What does refresh system mean, and what are its distinctive choice?
What is the commit type if you have a transaction control transformation in the mapping?