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
- 10208 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
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain in detail about scd type 1 through mapping.
What is the meaning of up gradation of repository?
Describe expression transformation?
Separate from an archive server and a powerhouse?
Differentiate between joiner and lookup transformation?
What are the differences between a connected lookup and unconnected lookup?
How we can use union transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is workflow manager?
What is aggregate cache in aggregator transformation?
What is the difference between Active and Passive transformation?
Is it possible to use a client with different version than that of its Informatica server?
