What is up date strategy and what are th options for update
strategy?

Answers were Sorted based on User's Feedback



What is up date strategy and what are th options for update strategy?..

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

What is up date strategy and what are th options for update strategy?..

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

Post New Answer

More Data Warehouse General Interview Questions

wat is code review and wat actually srs or how can we create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST.

1 Answers  


What is real-time datawarehousing?

0 Answers  


What are aggregate tables and aggregate fact tables?

0 Answers  


How do you define data block size?

0 Answers  


What is surrogate key? Where we use it? Explain with examples.

0 Answers  






What is the difference between Datawarehouse and OLAP?

0 Answers  


What is cost benefit analysis (cba)?

0 Answers  


ware house management system is used?

0 Answers  


What are situations where snowflake schema is better than star schema when the opposite is true?

0 Answers  


Explain in detail abt measure objects? And what is the use of it? How to create it?

0 Answers  


I have two universes created by two difference database can we join them in designer & report level? How

0 Answers  


Explain me what are data marts?

0 Answers  


Categories