Post reply

Slowly Changing Dimension Question

  • April 19, 2012 at 7:55 am

    #150896

    I am new to Slowly Changing Dimension in SSIS

    I have two tables the table structure as below

    USE Ticket

    GO

    CREATE TABLE Geetapc14

    (

    FirstName NVARCHAR(255),

    MiddleName NVARCHAR(255),

    LastName NVARCHAR(255),

    ContactID INT,

    CONSTRAINT pk_Geetapc14_pid PRIMARY KEY(ContactID)

    )

    CREATE TABLE Geetapc15

    (

    SalesOrderID INT,

    ContactID INT,

    TotalDue MONEY

    CONSTRAINT pk_Geetapc15_sid PRIMARY KEY(SalesOrderID)

    CONSTRAINT fk_Geetapc15_pid FOREIGN KEY(ContactID) REFERENCES Geetapc14(ContactID)

    )

    Source database is AdventureWorks

    Destination database or warehouse :Ticket

    I want to insert data into Geetapc14 table from AdventureWorks.Person.Contact table and Geetapc15 from AdventureWorks.Sales.SalesOrderHeader table

    I want to insert data in to there two tables using SCD in SSIS.Is it possible to do it .If yes what is the approach

  • April 20, 2012 at 8:30 am

    #1476682

    I have tried this it worked

    Created two data flow tasks one for 'Geetapc14' table and one for Geetapc15

    1. For the first data flow task selected source as 'AdventureWorks.Person.Contact table.Used SCD and selected FirstName,MiddleName,LastName,ContactID and selected ContactID as Business Key. Selected Change type as 'Fixed attribute'

    2. For the second data flow task selected source as 'AdventureWorks.Sales.SalesOrderHeader table.Used SCD and selected SalesOrderID, ContactID,TotalDue and selected ContactID as Business Key. Selected Change type as 'Fixed attribute'

    Set 'FailOnFixedAttributeChange' as false for the second SCD

    The package worked perfectly.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply