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
- 12168 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
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is a difference between complete, stop and abort?
update strategy transformation in informatica
what is index?how it can work in informatica
can anyone explain me about retail domain project in informatica?
Difference between Target-based loading and constraint-based loading?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Is it possible to define a single node as a Gateway node as well as worker node?
What is mapping debugger?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Where can we find the throughput option in informatica?
Explain why we use partitioning the session in informatica?
What are the new features of informatica 9.x in developer level?
Enlist the tasks for which source qualifier transformation is used.
Can we override a native sql query within informatica?
