Interested to Buy Any Domain ? << Click Here >> for more details...
What are the mapings that we use for slowly changing
dimension table?
- 2 Answers
- 10745 Views
- I also Faced
- E-Mail Answers
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
How can we use mapping variables in informatica? Where do we use them?
How do you use reject loader.
Informatica Checkpoints
What do mean by local and global repository?
how to load dimension table and fact table. plz tell me the steps.
What is joiner change?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What do think which one is the better joiner or look up?
How to update source definition?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
draw informatica architecture 8.6 ?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the advantage of informatica?
Explain sessions?
What is the commit type if you have a transaction control transformation in the mapping?
