How will you update the row without using update statergy?

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

Question Posted / radhakrishnansk

10 Answers
14968 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How will you update the row without using update statergy?..

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

How will you update the row without using update statergy?..

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

How will you update the row without using update statergy?..

Answer / g. manthiramoorthy

You can set the property at session level
"TREAT SOURCE ROWS AS: "Update"

Is This Answer Correct ?

8 Yes

0 No

How will you update the row without using update statergy?..

Answer / prasad

In target

there is a update override option is there using this one we
can update the records without using update strategy t/r

Is This Answer Correct ?

6 Yes

1 No

How will you update the row without using update statergy?..

Answer / ganesh

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

How will you update the row without using update statergy?..

Answer / har

i guess dynamic look up cache

Is This Answer Correct ?

3 Yes

4 No

How will you update the row without using update statergy?..

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

How will you update the row without using update statergy?..

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

How will you update the row without using update statergy?..

Answer / sushma

you can use SQL transformation

Is This Answer Correct ?

0 Yes

6 No

How will you update the row without using update statergy?..

Answer / radhakrishnansk

i guess procedural transformation.

Is This Answer Correct ?

0 Yes

11 No

Post New Answer