What are the mapings that we use for slowly changing
dimension table?
Answer Posted / swetha
Type1: Rows containing changes to existing dimensions are
updated in the target by overwriting the existing dimension.
In the Type 1 Dimension mapping, all rows contain current
dimension data.
Use the Type 1 Dimension mapping to update a slowly changing
dimension table when you do not need to keep any previous
versions of dimensions in the table.
Type 2: The Type 2 Dimension Data mapping inserts both new
and changed dimensions into the target. Changes are tracked
in the target table by versioning the primary key and
creating a version number for each dimension in the table.
Use the Type 2 Dimension/Version Data mapping to update a
slowly changing dimension table when you want to keep a full
history of dimension data in the table. Version numbers and
versioned primary keys track the order of changes to each
dimension.
Type 3: The Type 3 Dimension mapping filters source rows
based on user-defined comparisons and inserts only those
found to be new dimensions to the target. Rows containing
changes to existing dimensions are updated in the target.
When updating an existing dimension, the Informatica Server
saves existing data in different columns of the same row and
replaces the existing data with the updates.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
is it possible to index the data in cache of lkp transformation ?
Different qualification between a related rotate toward the sky and isolates look upward?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Differentiate between reusable transformation and mapplet.
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How to convert multiple rows to single row (multiple columns) in informatica
What is the use of transformation?
Different sorts of metadata that stores in the storage facility?
have u done any performance tuning? how u ll do?
design of staging area?
Explain lookup transformation is active in informatica
Can u generate reports in Informatica?
Tell me about Propagate functions in informatica
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?