In a table there are 1 million records there in which 3
records are duplicate how will you find out those 3 records?
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
Explain scd type 3 through mapping.
Can informatica load heterogeneous targets from heterogeneous sources?
What is meant by query override?
COM components can be used in Informatica
What is data caches/ index caches?
How are indexes created after completing the load process?
How to load the data from a flat file into the target where the source flat file name changes daily?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Can you generate sequence numbers without using the sequence generator transformation?
What is the format of informatica objects in a repository?
What is lookup transformation?
How can one identify whether mapping is correct or not without connecting session?
What are the measure objects?
What are the tuning techniques you applied during your last project
What is a repository? And how to add it in an informatica client?