What is up date strategy and what are th options for update
strategy?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guest
update strategy is a transformation which helps to flag a
record either to update ,delete,insert,reject
| Is This Answer Correct ? | 1 Yes | 0 No |
Why should you put your data warehouse on a different system than your oltp system?
How can we import and export using BCP utility?
Explain the definition of normalized and denormalized view and what are the differences between them?
Explain ddl (data definition language)?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
Explain multivalued dependency?
How can you import tables from a database?
OLAP architecture?
What are the data marts?
How to limit the max no of rows retrieved in the report?
Can we have more than one time dimensions in a Schema(Star or Snowflake)
What are cluster analysis in data warehousing?