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 |
Explain lookup transformation is active in informatica
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
What is the default join that source qualifier provides?
what is $$$$?
What is partioning?how many types of partinings are there
how to connect two or more table with single source qualifier?
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
what are types of dimentions?
in what type of scenario bulk loading and normal loading we use?
can we use bulk loading when we use look in mapping
what is session parameters?