Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for how to eliminate the duplicate rows
without using distinct?
- 6 Answers
- 12136 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / czarabid
it's very simple the question is to delete the duplicated
records and it's solution is here
DELETE FROM TABLE_NAME1 t1 WHERE ROWID </> any(SELECT ROWID
FROM TABLE_NAME1 t2 WHERE t1.column1=t2.column1);
this will delete only the redundant records leaving only one
copy of the same records in the table.
If you want to delete all the records which are redundant
then the solution is here
DELETE from table_name1 t1 where rowid <> any (select rowid
from table_name1 t2 where t1.no=t2.no)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How you can differentiate between connected lookup and unconnected lookup?
What are the limitations of joiner transformation?
How do you load only null records into target?
What do you understand by SOA of Informatica?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How to join three sources using joiner?
how many types of dimensions are available in informatica?
How does a rank transform differ from aggregator transform functions max and min?
Differentiate between Load Manager and DTM?
What are the modules in Power Center
How we can use union transformation?
define galaxy repository in informatica
How to load data in informatica ?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are the informatica performance improvement tips
