Interested to Buy Any Domain ? << Click Here >> for more details...
How will you update the row without using update statergy?
- 10 Answers
- 14994 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 |
what is system requirement(SR) & business requirement(BR)?
What are the types of lookup?
What are the differences between source qualifier and joiner transformation?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
Define pmcmd command?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
What are different types of transformations available in informatica?
Explain pushdown optimization and types in informatica
How to jion 2 tables, without using any condition?
Can any one explain or sujjest some sites for scd mappings.Thank you
Teradata 
