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
How can we use batches?
Different sorts of metadata that stores in the storage facility?
Explain the pipeline partition with real time example?
Design time, run time. If you don't create parameter what will happen
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
explan ur project architecture?
What do you understand by term role-playing dimension?
What is a filter transformation and why it is an active one?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Is it possible to define a single node as a Gateway node as well as worker node?
what is Active lock explain
How do you take back up of repository?
update strategy transformation in informatica
What is meant by LDAP users?
What are the conditions needed to improve the performance of informatica aggregator transformation?
