Interested to Buy Any Domain ? << Click Here >> for more details...
In a table there are 1 million records there in which 3
records are duplicate how will you find out those 3 records?
- 6 Answers
- 9077 Views
- I also Faced
- E-Mail Answers
Answer Posted / lokesh vepanjeri
select * from emp where rowid not in (select max(rowid)
from emp group by empno);
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Where is metadata stored?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How do you handle two sessions in Informatica
Please let me know how to make encryption and decryption with example?
Enterprise data warehouse your projects phase by phase explain?
What is workflow manager?
What is session task and command task?
How can we use mapping variables in informatica? Where do we use them?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is rank transform?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Enlist few areas or real-time situations where informatica is required.
What does refresh system mean, and what are its distinctive choice?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Explain target update override in informatica
