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
- 41681 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
What's the layout of parameter file (what does a parameter file contain?)?
What are the types of schemas we have in data warehouse.
How to load the data from people soft hrm to people soft erm using informatica?
lookup transformation with screenshots
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is sorter transformation?
How does the aggregator transformation handle null values?
What is workflow? What are the components of the workflow manager?
What is an active transformation?
What is an expression transformation in informatica?
Which files are created during the session rums by informatics server?
What is the use of source qualifier?
What is informatica metadata and where is it stored?
What is the need of an ETL tool?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
