Interested to Buy Any Domain ? << Click Here >> for more details...
How will you update the row without using update statergy?
- 10 Answers
- 15235 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 |
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
Differentiate between joiner and lookup transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
Why use shortcuts(Instead of making copies).
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
Diff b/w ShortCut and reusabel Object ?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
server hot-ws270 is connect to Repository B. What does it mean?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
I have 1200 records how can u send it in aggregator with good performance issues?
Teradata 
