How can u insert o ne row in the target if that row does not
exists in the target and update if it exists
Answer Posted / sujana
by using scd type2 v can do dis
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
Explain in detail about scd type 1 through mapping.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
can we override a native sql query within informatica? How do we do it?
What are active transformations.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain what transformation and how many are there in informatica?
If informatica has its scheduler why using third party scheduler?
Explain about Informatica server process that how it works relates to mapping variables?
What is source qualifier transformation in informatica?
Why do you use Mapping Parameter and mapping variable?
What is the format of informatica objects in a repository?
What is session task and command task?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
list out all the transformations which use cache?
How to extract sap data using informatica? What is abap? What are idocs?