without update strategy how to insert &update?
Answer / 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 |
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
What are the types of data that passes between informatica server and stored procedure?
how lookup is acting as both active and passive ? how is it possitble?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
How we can create indexes after completing the load process?
what are the transformations that restricts the partitioning of sessions?
How to load data in informatica ?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
Write the program through which the records can be updated?
Do joiner transformation use cache? If so describe?
What is a connected transformation?
what is incremental aggregation ,with example?