How we can get unique records into one target table and
duplicate records into another target table??

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


Please Help Members By Posting Answers For Below Questions

How can we use mapping variables in informatica? Where do we use them?

843


Explain scd type 3 through mapping.

773


what is unit testing?tell me proceedure

1992


Clarify the aggregator change?

785


What is target load order?

1015


how to create user defined function (udf) in informatica

1033


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

891


Why update strategy and union transformations are active?

816


what is diff b/t sorter t/r and agg have the option sorter property...

1961


What are the various types of transformation?

895


How can we store previous session logs?

787


What is the difference between stop and abort in informatica

876


Can we create a node as a gateway node and the same node can be assigned to a grid?

852


What is the way to execute pl/sql script using informatica mapping?

1258


How to partition the Session?

852