Interested to Buy Any Domain ? << Click Here >> for more details...
What is target update override
- 2 Answers
- 7560 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ash
By Default the intergration service updates the target
based on key columns. But we might want to update non-key
columns also,at that point of time we can override the
UPDATE statement for each target in the mapping.The target
override affects only when the source rows are marked as
update by an update strategy in the mapping.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / usha
target update override which is used to update the data
with out using UPDATE transformation....
if there is no PK in the target we can update by using
target update override
| Is This Answer Correct ? | 1 Yes | 0 No |
What is difference between a connected look up and unconnected look up?
Separate from an archive server and a powerhouse?
What is a command that used to run a batch?
How to recover the standalone session?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
can v update d records in target using update stargey without generationg primary key ? explain
What is the command used to run a batch?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
what is materialized view?
Teradata 
