How we can get unique records into one target table and
duplicate records into another target table??
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
Clarify the utilization of aggregator cache record?
What is a stored procedure transformation?
What is informatica etl tool?
Enterprise data warehouse your projects phase by phase explain?
Differentiate between joiner and lookup transformation?
Enlist the advantages of informatica.
What is the function of aggregator transformation?
Explain in detail scd type 2 through mapping.
what is Active lock explain
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to join three sources using joiner?
What are the types of caches in lookup? Explain them.
What is workflow? What are the components of the workflow manager?
What are active transformations.
Explain about cumulative Sum or moving sum?