Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)
- 6 Answers
- 10064 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / dilip ingole
Delete from emp where rowid not in(select min(rowid) from emp group by eid,ename)
in group by column you need mention all column in table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How does the aggregator transformation handle null values?
explain abt ur project architecture?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Explian the Process of deployment groups in informatica
Explain incremental aggregation in informatica
Can we create two repositories on same database instance in oracle?
What is meant by query override?
Where are the source flat files kept before running the session?
What is meant by active and passive transformation?
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??
How do you load only null records into target? Explain through mapping flow.
What is the use of source qualifier?
What are the different types of transformation available in informatica.
can u any challenge your project?
what is song in infrmatica...?
