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
How can we use mapping variables in informatica? Where do we use them?
Explain scd type 3 through mapping.
what is unit testing?tell me proceedure
Clarify the aggregator change?
What is target load order?
how to create user defined function (udf) in informatica
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.
Why update strategy and union transformations are active?
what is diff b/t sorter t/r and agg have the option sorter property...
What are the various types of transformation?
How can we store previous session logs?
What is the difference between stop and abort in informatica
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the way to execute pl/sql script using informatica mapping?
How to partition the Session?