without update strategy how to insert &update?
Answer Posted / nivas
First you create the mapping according to your requirement
after that you create session.
Double click the session and then select properties tab in
the properties tab choose Target Rows Source as what do you
want (Insert, update,delete, Datadriven(this is only when
your using update stratogy transformation in the mapping)).
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain in detail scd type 2 through mapping.
Enlist the differences between database and data warehouse.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What are the advantages of using informatica as an etl tool over teradata?
Write the different tools in the workflow manager?
Is it possible to revert a global repository to local one and why?
What is meant by query override?
define galaxy repository in informatica
Scheduling properties,whats the default (sequential)
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the fact table?
What is DR strategy for Informatica project?
What all are steps in up gradation of Informatica server?
What is xml source qualifier transformation in informatica?
Explain the pipeline partition with real time example?