Interested to Buy Any Domain ? << Click Here >> for more details...
How will you update the row without using update statergy?
- 10 Answers
- 14837 Views
- CTS, I also Faced
- E-Mail Answers
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 |
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
How can we handle two sessions in informatica?
how to get the only updated records in the target
what is mystery dimension?
What do you mean by channel change?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
In Which scenario did u used Incremental loading?
How will you check the bottle necks in informatica? From where do you start checking?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?
How informatica recognizes mapping?
Teradata 
