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
- 9075 Views
- I also Faced
- E-Mail Answers
Answer Posted / haribabu
select ename,empno,count(*) from emp group by empno having count(*)>1;
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How can repository reports be accessed without sql or other transformations?
What is the use of target designer?
What is intricate mapping?
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
How do you promote a non-reusable transformation to reusable transformation?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
While migrating the data from one environment to another environment how would you manage the connections?
What is the use of an aggregator cache file?
What is the need of etl tools?
How many types of sessions are there in informatica.please explain them?
How can we store previous session logs?
What is sorter transformation?
What is a sequence generator transformation?
what is informatica metadata?
How can you increase the performance in joiner transformation?
