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
What is informatica? Why do we need it?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
While migrating the data from one environment to another environment how would you manage the connections?
Explain the difference between mapping parameter and mapping variable?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is the difference between informatica 7.0 and 8.0?
Differences between connected and unconnected lookup?
What is transformation?
What are the different options available for update strategy?
Explain sessions. Explain how batches are used to combine executions?
Implementation methodology
Whats the difference between informatica powercenter server, repositoryserver and repository?
How can you generate reports in informatica?
What are the new features of informatica 9.x developer?