Interested to Buy Any Domain ? << Click Here >> for more details...
Insert else update option in which situation we will use
- 4 Answers
- 11283 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Plz can any one say me how to get the informatica certification materials and dumps
What is mapplet in informatica?
What is Session and Batches?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How to configure mapping in informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Differentiate between joiner and lookup transformation?
Different sorts of metadata that stores in the storage facility?
When do you use sql override in a lookup transformation?
Explain the mapping variable usage example in informatica
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
According to his methodology what all you need before you build a datawarehouse
How do you load only null records into target?
What differs when we choose the sorted input for aggregator transformation?
