Type 3 Slowly Changing Dimension
I am trying to find a best example / scenario where a type 3 scd would make more sense than a type 2. In my understanding type 3 can easily be derived from type 2. If anybody has used type 3 dimension instead of type 2, please let me know the scenario an

Loading Fact Table with Type 2 Slowly Changing Dimension
I'm new to data warehousing .. sorry if this is a basic question. I have a type 2 slowly changing dimension already loaded and now I want to load a fact table. At least, I think it should be a fact table. A lot of the entities in the dimension table

Unsure about relationship with Slowly Changing dimensions.
Hi Sorry datawarehouse newbie question! I have many years experience with relational databases but my head is not yet around the dimensional model. I am not sure how to maintain the relationship between Fact and Type 2 Dimension. i.e if a new row is

Slowly Changing Dimension table
Hello, I have scenario where we are creating a Dimension Table and Fact Table from the same Source Table which contains both descriptive and numeric data I want to model the Dimension table as a Slowly changing Dimension Type 2 (create new

Slowly Changing Dimensions - Design Review (Need More Clarification)
Hello, Suppose I have following Fact and Dim table CustomerDim CustomerKey CustomerID CustomerNumber CustomerName CreditLimit - Slowly Changing, wants history IsAnnualMember - Slowly Changing, can be different from year to year or

SSIS and the SQL 2008 MERGE Statement for Insert, Update and Delete
The 'MERGE' statement in SQL 2008 seems a powerful tool for managing incremental ETL. Seems lots of examples of using from SSMS, but few (none?) of calling from within the SSIS framework. Hopefully in Denali we'll see a package object OOTB that can

ETL from Oracle to SQL Server 2008 Data Warehouse
Hello, Our data warehouse runs on SQL 2008 servers. One of the transactions systems we have runs on an Oracle database and managed by a separate team. What are the recommended methods to extract source data from an Oracle database and loading to a

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)
Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

How to Track SCD Type 2 for Accumlating or Periodic Snapshot
Hi, I am looking to create a Periodic Snapshot fact and Accumulating snapshot fact for Backlog of orders and order completion. I tried searching in this forum as to how to model this scenario SCD type 2, but unable to find any. If I have to carry over

SQL Server 2008 Date data type as dimension key
We are getting ready to migrate from Microsoft SQL Server 2005 to 2008. Currently we use an integer (in YYYYMMDD format) as the SK on our date dimension table. I am very tempted to start using the new 3-byte Date data type (which stores only the date

Rapidly Changing Dimension
Hello, I have a slowly changing dimension table with 105 attributes. About 85% of the attributes are type 1 and the remaining 15% are type 2. I have 4 fields that are type 2 that change a lot more frequently than the rest of the type 2 fields. On a

SCD Type 2 dimension and fact table being the same table
I am designing a dimensional model for employee data in a data warehouse. Right now I only register the basic information about the employee, like job title, department, language, FTE, etc. I have chosen to use an SCD Type 2 dimension since I want to keep

How to split the dimension members with SCD Type 2?
Hi all, I want to create dimension table, where will be some members and each of them has its own history (so it has own versions in time), where at one time is one and only one always valid. So it is commonly solved by SCD Type 2. For exampl

FACT table Incremental load!
Hi I have huge data source (1TB), that data source table is not well designed, its primary keys are four columns which are all nvarchar! and in that source there is no date filed neither a serial or sequence #! my question, how I can implement an

MDX(or something else) for getting history based on last dimension characteristic for SCD.
Hi everyone, I am implementing a cube and I run into a problem with slowly changing dimensions(SCD type 2). I guess it might be resolved somehow with MDX or somehow else, maybe you guys can help me to resolve it. The problem: I have SCD, say Policy wit