Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / purva
Slowly changing dimensions are dimension tables that have
slowly increasing dimension data, as well as updates to
existing dimensions.
Ex : if a person Mr. x is living in the city C1 has a
transaction in a bank and his details is maintained and
after some years he moves to city C4, that means he has his
new details develped but the bank need to maintain the
details i.e both c1 and c2 details ,the history has to be
maintained fully or sometimes partially , so in this cases
the necessity of SCD is required
When updating existing dimensions, you decide whether to
keep all historical dimension data, no historical data, or
just the current and previous versions of dimension data.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is the different lookup cache(s)?
What are mapplets? How is it different from a Reusable Transformation?
Explain constraint based loading in informatica
How you can differentiate between connected lookup and unconnected lookup?
Why do you use Mapping Parameter and mapping variable?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How can we handle two sessions in informatica?
Differentiate between sessions and batches?
Explain the pipeline partition with real time example?
Difference between Data and Index Caches?
Differentiate between a repository server and a powerhouse?
In which transformation you cannot drag ports into it?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is Data Caches size?
What is a filter transformation?
