Interested to Buy Any Domain ? << Click Here >> for more details...
Insert else update option in which situation we will use
- 4 Answers
- 11280 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a mapplet/worklet in informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to generate sequence numbers?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
what is the complex transformation you used in informatica
Explain sessions?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
explain abt ur project architecture?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is domain in terms of informatica?
What is update strategy transform?
Explain scd type 3 through mapping.
