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
- 12094 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / murali udayagiri
Assume some duplicate data is there in emp table. Try the
below to eliminate duplicate.
select * from emp
union
select * from emp;
Thanks,
Murali Udayagiri
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
can we override a native sql query within informatica? Where do we do it? How do we do it?
Write the advantages of partitioning a session?
Is it possible to use a client with different version than that of its Informatica server?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the differences between joiner transformation and source qualifier transformation?
How to generate sequence numbers using expression transformation?
Which are the different editions of informatica powercenter that are available?
can you please explain me pre session and post session options?
How to partition the Session?
Explain lookup transformation in informatica
Define the various join types of joiner transformation?
What is fact table? Explain the different kinds of facts.
What is source qualifier transformation in informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
On which transformations you created partitions in your project?
