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
What is meant by target load plan?
where to store informatica rejected data? How to extract the informatica rejected data?
what is the complex transformation you used in informatica
What are the types of schemas we have in data warehouse.
Explain target update override in informatica
Which means the first record should come as last record and last record should come as first record and load into the target file?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
If informatica has its scheduler why using third party scheduler?
What are the new features of informatica 9.x developer?
Explain the tuning lookup transformation - informatica
How can we improve session performance in aggregator transformation?
Difference between Data and Index Caches?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is native users?
Performance tuning in UNIX for informatica mappings?
