How will you update the row without using update statergy?
Answers were Sorted based on User's Feedback
Answer / bobby
I think in the session Properties, we can update or insert
the record with out using update strategy in the mapping.
I think it works. If i am wrong let me know
Is This Answer Correct ? | 22 Yes | 0 No |
Answer / sweta kedia
In target,there is a update override option of updating the
records using the non-key columns. Using this one wecan
update the records without using update strategy t/r
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / g. manthiramoorthy
You can set the property at session level
"TREAT SOURCE ROWS AS: "Update"
Is This Answer Correct ? | 8 Yes | 0 No |
1) If the target table doesn't have primary key, then using
update override we can update the records.
2) If target table have primary key, then we have option
called update else insert in session properties. Based upon
that we will update the records.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / shiv
you can set the property at session level TREAT SOURCE ROWS
AS 'DATA DRIVEN'. BECOUSE WE CAN SET UPDATE AT MAPPING
LEVEL AND SESSION LEVEL.
Is This Answer Correct ? | 3 Yes | 5 No |
Answer / balaji
Hi,
Yes. Following above answers.,
We have to keep the checkmark for Update and also needs to
keep Load source as "Data Driven". Moreover, we need to also
take care that target updating table is getting updated
based on one or more Key value in it.
Thanks,
S Balaji.
Is This Answer Correct ? | 0 Yes | 5 No |
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
How to do unit testing in informatica?
What are the different lookup cache(s)?
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
What is the Rankindex in Ranktransformation?
What is the difference between IN and Exists in Oracle?
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
How can we get multiple output values using an unconnected lookup transformation?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?