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
- 9259 Views
- I also Faced
- E-Mail Answers
Answer Posted / vivek singh
select * from emp1
where rowid not in (select max(rowid) from emp1 group by empno);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Clarify the utilization of aggregator cache record?
How can one identify whether mapping is correct or not without connecting session?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is the difference between stop and abort in informatica
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Quickly characterize reusable change?
What is persistent lookup cache?
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
How we can create indexes after completing the load process?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
can anyone explain me about retail domain project in informatica?
Briefly define reusable transformation?
During the running session, output files are created by informatica server. Enlist few of them.
How to do unit testing in informatica?
Explain the pipeline partition with real time example?
