What is up date strategy and what are th options for update
strategy?
Answer Posted / madhuri
Update Strategy allows us to decide what to do with the
data(INSERT,DELETE,UPDATE or REJECT) based on conditions
defined.We can achieve this thru the mapping designer using
transformation or we can do this also at the session level
by using the treat source rows as option.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How did you plan your Data ware house project?
What is freehand sql?
what are different storage options supported by oracle ?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What are the stages that are required in data warehousing?
What is operational data store (ods)?
Explain the data type of the surrogate key?
Where do we use semi and non additive facts?
What is latest version of power center / power mart?
I need to set predefined condition. How I do this?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is core dimension?
Briefly state different between data ware house & data mart?
What is the difference between Datawarehouse and OLAP?
Compare aggregates and data marts