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
without table how to come first record only in oracle?
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?
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??
How to load last n records of file into target table - informatica
What are the transformations that are not supported in mapplet?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
During the running session, output files are created by informatica server. Enlist few of them.
Define mapplet?
Explain why we use partitioning the session in informatica?
What are the guidelines to be followed while using union transformation?
In which transformation you cannot drag ports into it?
What are different types of transformations available in informatica?
Enlist few areas or real-time situations where informatica is required.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Can you generate sequence numbers without using the sequence generator transformation?