SCD ( Slow Changing Dimension ) – COGNOS

SCD ( Slow Changing Dimension ) ada tiga type :

1. Type 1 : Menyimpan informasi data terakhir/terbaru dan tidak menyimpan data history

2. Type 2 : Menyimpan informasi data terakhir/terbaru dan informasi data history (Full History)

3. Type 3 : Menyimpan informasi data terakhir/terbaru dengan informasi sebagian saja data history (Not FULL)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s