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
- 12101 Views
- iGate, I also Faced
- E-Mail Answers
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
Repository user profiles
What are the differences between joiner transformation and source qualifier transformation?
have u done any performance tuning? how u ll do?
What is powercenter on grid?
Explain dynamic target flat file name generation in informatica
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Where are the source flat files kept before running the session?
What is the function of aggregator transformation?
How can you validate all mappings in the repository simultaneously?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain incremental aggregation in informatica
What are ETL Tools?
How to load a Dimension ? and how to load a fact table?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
what is Active lock explain
