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
- 41145 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 are mapplets? How is it different from a Reusable Transformation?
Define Pmrep command?
Explain the different kinds of facts.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Write the advantages of partitioning a session?
Where do we use mapping variables in informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are active and passive transformations?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explain sql transformation in script mode examples in informatica
Can informatica load heterogeneous targets from heterogeneous sources?
What is the difference between router and filter?
difference between repository database and repository service?
What is the benefit of session partitioning?
