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
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is an expression transformation?
Is there any target staging area in informatica not staging area
What is dimensional table? Explain the different dimensions.
How to load the data from people soft hrm to people soft erm using informatica?
Enlist the differences between database and data warehouse.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How to improve the performance of a session using sorter transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to do unit testing in informatica? How to load data in informatica ?
What do you understand by a term domain?
Explain what are the different versions of informatica?
What is different between the data warehouse and data mart?
How many input parameters can exist in an unconnected lookup?