1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What are slowly changing dimensions?

Question Posted / sri ram

Answer Posted / sri ram

Slowly Changing Dimensions:(SCD)
Over period of time, the value /data associated with
dimensions may change. To track the changes we record the
changes as per the requirement.
There are three types of SCD
SCD 1:No history is maintained. As and when data comes, the
data is entered.
SCD 2: History is maintained
SCD 3: Partial History is maintained.
We maintain history for some columns but not for all.
For example,I have 3 records in a dimension
I have made 1 insert and 1 update. Then if the requirement
is that dimension is to be maintained
In SCD 1 Then
Total number of records is 4 records(1 insert & 1 update)
In SCD 2 Then
Total number of records is 5 records(1 insert & 1 update)
In SCD 3 Then
Total number of records is 4 records(1 insert & 1 update)
NOTE:
History means the slight change in the data stored and
incoming data but it doesn't means years of data.

Is This Answer Correct ?    36 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the benefit of partitioning a session?

624

What is union transformation?

572

Explain lookup transformation source types in informatica

696

What are the different options available for update strategy?

577

What is the procedure for creating independent data marts from informatica 7.1?

565




How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1616

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)

1077

Define filter transformation?

626

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1516

What is the difference between router and filter?

647

How many transformations can be used in mapplets.

1456

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1526

What are the limitations of joiner transformation?

651

On which transformations you created partitions in your project?

761

What is the difference between a repository server and a powerhouse?

805