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
- 12351 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
What is the use of an aggregator cache file?
What are the measure objects?
Do you find any difficulty while working with flat files as source and target?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How do you use reject loader.
How to create Target definition for flat files?
How union transformation is used?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
tell me about your project functionality
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Difference between Target-based loading and constraint-based loading?
Mention a few design and development best practices for informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What do you mean incremental aggregation?
Explain the features of connected and unconnected lookup.
