Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Monday, 9 September 2013

SCD Type 2 in Informatica


By on 04:26:00



SCD -2 Implementiation in informatica


1. We have a flat file as shown below


SCD Type 2  in Informatica
SCD Type 2  in Informatica












SCD Type 2  in Informatica
SCD Type 2  in Informatica


2. Pull the source (emp.txt) to Source Analyzer

3. Develop the Mapping

Go to Mappings > Wizards > Slowly Changing Dimensions

Enter the New Mapping Name as M_EMP_SCD_TYPE2 and 

choose 2nd Option Type 2 Dimension – Keep a full history of changes in the target click next

SCD Type 2  in Informatica
SCD Type 2  in Informatica

Select the Source file (FlatFile:emp) & enter the New Target Table Name as EMP_SCD_T



SCD Type 2  in Informatica
SCD Type 2  in Informatica



Click Next

Move the emp_id to Logical Key Fields

Move the Other columns to Field to compare for changes

SCD Type 2  in Informatica
SCD Type 2  in Informatica



Click Next



Choose the Third Option – Mark the dimension records with their effective date range

SCD Type 2  in Informatica
SCD Type 2  in Informatica



Click Finish

The Mapping will be created as below 

SCD Type 2  in Informatica
SCD Type 2  in Informatica

Give the Connection Information to lookup table here (LKP_GETDATA)



4. Generate and Execute the target table (EMP_SCD_T) in Target Analyzer 

5. Save the Record

6. Generate the Session and Workflow for this mapping

7. Run the Workflow

We got Output like



SCD Type 2  in Informatica
SCD Type 2  in Informatica



Now in Flatfile change the location for emp_id 5003

SCD Type 2  in Informatica
SCD Type 2  in Informatica

Run the Workflow, 

Output

SCD Type 2  in Informatica
SCD Type 2  in Informatica

Here new primary key is assigned for new record (5003) and also end date is set for old record



0 comments:

Post a Comment

Blog Archive

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)