Interested to Buy Any Domain ? << Click Here >> for more details...
How we can get unique records into one target table and
duplicate records into another target table??
- 11 Answers
- 41189 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answer Posted / naveen
Answer #3 is correct by Nag.
Addition to above second query for duplicate records, will
return unique records for each duplicate records.
if you need all duplicates records thn follow the below
query.
select * from emp
where empno in (select empno from emp group by empno having
count(empno)>1)
Regards,
Naveen
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How we can create indexes after completing the load process?
What is a dimensional model?
What do you understand by SOA of Informatica?
Mention few advantages of router transformation over filter transformation.
What is exclusive and normal mode for repository services?
How identifying bottlenecks in various components of informatica and resolving them?
Explain your project of banking domian.
how we can load rejected record's at run time?(not through bad files)
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Is stop and abort are same in informatica?
Explain sessions?
whats the logic to load the lower level of granularity of data to fact table.
tell me the rules and responsblites in our project(my project is development)
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Design a mapping to load the cumulative sum of salaries of employees into target table?
