Interested to Buy Any Domain ? << Click Here >> for more details...
What are the mapings that we use for slowly changing
dimension table?
- 2 Answers
- 10831 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
What is the reusable transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Performance tuning in UNIX for informatica mappings?
How to partition the Session?
What is the format of informatica objects in a repository?
How to use procedural logic inside infromatica?
What do you mean incremental aggregation?
Explain lookup transformation in informatica
What is Index Caches size?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is complex mapping?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
have u done any performance tuning? how u ll do?
What is flashback table ? Advance thanks
How many ways are there to create ports?
