Insert else update option in which situation we will use
Answers were Sorted based on User's Feedback
Answer / mike
as per my knowledge
when we use update strategy transformation we will come
across to use this...insert else update...
let us suppose we have two tables a and b. a is the source
table and b is the target table...let us take b which is
target table contains some matched records with 'a' which
is source table. If source table 'a' is modified and
inserted with some records,here we need to update the
records in the target table...therefore by using the insert
else update option in the session properties of target we
can insert new records and update the existing records
correct me if i was wrong
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / naveen
This option we use when we want to maintain the history.
if records are not availabe in target table then it inserts
the records in to target and records are available in
target table then it updates the records.
Regards,
Naveen
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / madhavi
if the source table contain multiple records .if the record specified in the associated port to insert into lookup cache. it does not find a record in the lookup cache when it is used find the particular record & change the data in the associated port.
Is This Answer Correct ? | 0 Yes | 2 No |
How to fix the etl bugs..Tell me the process?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
How many dimensions are there in informatica?
What is a standalone command task?
How to go to the older version for a mapping?
Why union transformation is an active transformation?
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
how to connect two or more table with single source qualifier?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.