write a query for how to eliminate the duplicate rows
without using distinct?
Answer Posted / mani
DELETE FROM EMP WHERE ROWID NOT IN (SELECT MAX(ROWID)FROM
EMP)GROUP BY EMPNO;
Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What are the types of data warehouses?
Explain the mapping variable usage example in informatica
Describe data concatenation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
expain about the tune parameters?
What is incremental aggregation?
Differentiate between sessions and batches?
Under what condition selecting sorted input in aggregator may fail the session?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is main use of mapplet?
Can anyone tell me the new features in Informatica 9 Version?
What are active transformations.
Explain about cumulative Sum or moving sum?
Performance tuning in UNIX for informatica mappings?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?