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
Explain the shared cache and re-cache?
What are data-driven sessions?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Differentiate between source qualifier and filter transformation?
Mention few advantages of router transformation over filter transformation.
How to implement security measures using repository manager?
What are the advantages of informatica?
What is the command used to run a batch?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What could be the possible resons of locks by user?
COM components can be used in Informatica
Tell me about Propagate functions in informatica
Define update strategy?
Do you find any difficulty while working with flat files as source and target?
What is a snowflake schema?
