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
- 9508 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
Tell me about Propagate functions in informatica
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
explain about unit testing? in real time?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is a sorter transformation?
list out all the transformations which use cache?
What are data-driven sessions?
Difference between Target-based loading and constraint-based loading?
Write the unconnected lookup syntax and how to return more than one column.
Explain Dataware house architecture .how data flow from intial to end?
What is a difference between complete, stop and abort?
How to generate sequence numbers?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Define the various join types of joiner transformation?
