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
- 10455 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
Can we change Dynamic to Static or Persistent cache? If so what happens?
Is it possible to create multiple domains on a single Informatica server?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is aggregate cache in aggregator transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How do you load unique records into one target table and duplicate records into a different target table?
What are the different types of olap? Give an example?
differences between service based and product based?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Which development components of informatica have the highest usage?
Write the prerequisite tasks to achieve the session partition?
What is the commit type if you have a transaction control transformation in the mapping?
What are the transformations that are not supported in mapplet?
