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
- 9339 Views
- I also Faced
- E-Mail Answers
Answer Posted / vivek singh
select * from emp1
where rowid not in (select max(rowid) from emp1 group by empno);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why union transformation is an active transformation?
design of staging area?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
waht type of interface is used for testing the data in informatica
What is the use of source qualifier?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Define sessions in informatica etl?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Clarify the aggregator change?
Explain incremental aggregation in informatica
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How does the aggregator transformation handle null values?
How do you take back up of repository?
What is the Rank index port in Rank transformation?
Explain the pipeline partition with real time example?
