one source to target loading insert new rows and update
existing rows?
Answer Posted / ppl
using scd type 2 v can do dis
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What do you mean by blocking transformation?
Define pmcmd command?
Which transformation should we use to normalise the COBOL and relational sources?
Why do we need informatica?
Define sessions in informatica etl?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Informatica settings are available in which file?
Explain the different lookup methods used in informatica?
How we can create indexes after completing the loan process?
What are the different components of powercenter?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is expression transformation?
What are the advantages of using informatica as an etl tool over teradata?
What is a shortcut and copy in Informatica and how two are different with each other?