Interested to Buy Any Domain ? << Click Here >> for more details...
In a table there are 1 million records there in which 3
records are duplicate how will you find out those 3 records?
- 6 Answers
- 9330 Views
- I also Faced
- E-Mail Answers
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 is Cognos script editor?
What is powercenter on grid?
What is a grid in Informatica?
How to open an older version of an object in the workspace?
What is complex mapping?
What is the use of transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
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
How to differentiate between the active and passive transformations?
wat are deployement groups in informatica, how it will be used for developers
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Explain the etl program with few examples.
How might you approve all mappings in the archive all the while?
what is the size of u r source(like file or table)?
What is a joiner transformation and why it is an active one?
