Is scd logic we have lookup right to compare the values with
source and target,instead of lookup can u have any
transformation or any way to do this?
Answer Posted / naga
We can write Left outerjoin with the target in Source
Qualifier itself or if ur src is file & target is Table
then using Joine(Left outer) can get the new rows loaded
into target
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is dimensional table? Explain the different dimensions.
How to extract sap data using informatica?
Is it possible to revert a global repository to local one and why?
difference between informatica 8.1.1 and 8.6
What is the sql query overwrite in source qualifier in informatica
what are 3 tech challenges/ common issues you face?
What is a pre-defined event and user-defined event?
What is the difference between router and filter?
What is the difference between stop and abort in informatica
How does a sorter cache works?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Mention few power centre client applications with their basic purpose?
How do we call shell scripts from informatica?
What is workflow monitor?