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
- 9254 Views
- I also Faced
- E-Mail Answers
Answer Posted / santosh kumar sarangi
select * from emp where empno in (select empno from emp
group by sal having count(*)>1)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Describe an informatica powercenter?
What are the different transaction levels available in transaction control transformation?
Briefly explain the aggregator transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Which are the different editions of informatica powercenter that are available?
Under which circumstances, informatica server creates reject files?
can anyone explain me about retail domain project in informatica?
What is powercenter on grid?
can you please explain me pre session and post session options?
Reusable transformation and shortcut differences
Please let me know how to make Data masking in informatica..
Do you find any difficulty while working with flat files as source and target?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Make a note of the quantity vaults made in informatica?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
