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
- 11868 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / madhu
DELETE FROM EMP WHERE ROWID NOT IN (SELECT MAX(ROWID)FROM
EMP GROUP BY EMPNO);
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Define enterprise data warehousing?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Explain load alternative records / rows into multiple targets - informatica
where to store informatica rejected data?
How do you use reject loader.
What do you mean by channel change?
What is a code page?
What is the benefit of partitioning a session?
wf dont have integration severances how you can run?
How would you copy the content of one repository to another repository?
Explain dynamic target flat file name generation in informatica
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
