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
Explain which columns go to the fact table and which columns go the dimension table?
What does level of granularity of a fact table signify?
What are the tools available for etl?
What are the various file formats involved in reportnet?
What are the steps to build the datawarehouse?
What is recovering sessions?
Explain dimensional modelling?
What is index awareness in universe?
What are non-additive facts in detail?
How to export mappings to the production environment?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
Compare aggregates and data marts
What is factless fact tables?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in