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 some of modeling tools available in the market?
What are universe requirements?
Difference between cold fusion 5 and cold fusion mx 6?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What are Non-additive facts?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What is informatica architecture?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
Can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain multivalued dependency?
What is degenerate dimension table?
What is batch processing?
What are algorithms provided by Microsoft in SQL Server?
What are non-additive facts in detail?
What is incremintal loading?