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
- 40654 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answer Posted / usha
1st method by using expression transformation by adding
variable ports.
2nd method by using dynamicLKP we can load UNIQ records to
one taget table and DUPLICATE records to other target table
newLKProw=1(Insert)
newlkprow=0(if there is no difference in associate ports)
UNIQ records
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
Can we create two repositories on same database instance in oracle?
Explain lookup transformation is active in informatica
what is the -ve test case in your project.
Define joiner transformation?
Define mapplet?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Please let me know how to make Data masking in informatica..
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Do you find any difficulty while working with flat files as source and target?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
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.
How many number of sessions can one group in batches?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Slowly changing dimensions, types and where will you use them
What is substr in informatica?
