Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sai suresh
SCD: Slowly changed dimention
The SCD how to Capture the change data with respect to the
time. For ex: In an organization emp sal is chaged
according to his perfomence after chaned sal we kept in
datawarehouse. (Datawarehouse maintain a Historical data )
there are 3 types of SCDs.
Type1: It will maintain curren data only. It does't
maintain historical data.
Type2: It maintain current and historical data.
Type3: It maintain current and previous data it mease
Parcial data only maintain.
So generelly datawarehouser is maintain Historical data
hence Type 2 is useful
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
Write the program through which the records can be updated?
What is an unconnected transformation?
define galaxy repository in informatica
How to do unit testing in informatica?
Whats there in global repository
What is fact table? Explain the different kinds of facts.
what is index?how it can work in informatica
Mention some types of transformation?
What are the mapping parameters and mapping variables?
What is the difference between a connected look up and unconnected lookup?
What is meant by LDAP users?
Explain lookup transformation is active in informatica
What is workflow manager?
What are the differences between oltp and olap?
What is transformation?
