Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of Type2 dimension maping?
- 1 Answers
- 5536 Views
- I also Faced
- E-Mail Answers
Answer Posted / swetha
source will gets inserted in target along with a new
version number. And newly added dimension in source will
inserted into target with a primary key.
Type2 Dimension/Flag current Maping: This maping is also
used for slowly changing dimensions.In addition it creates a
flag value for changed or new dimension.
Flag indiactes the dimension is new or newlyupdated.Recent
dimensions will gets saved with cuurent flag value 1. And
updated dimensions r saved with the value 0.
Type2 Dimension/Effective Date Range Maping: This is also
one flavour of Type2 maping used for slowly changing
dimensions. This maping also inserts both new and changed
dimensions in to the target. And changes r tracked by the
effective date range for each version of each dimension.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How would you join a node to the already existing domain?
What is lookup transformation?
Performance tuning in UNIX for informatica mappings?
Explain the difference between mapping parameter and mapping variable?
What are Dimensional table?
Which development components of informatica have the highest usage?
How can we use mapping variables in informatica? Where do we use them?
What is intricate mapping?
Write the advantages of partitioning a session?
How can informatica be used for an organization?
Separate from a database, an information bazaar, and an information stockroom?
what is the -ve test case in your project.
How to load the data from a flat file into the target where the source flat file name changes daily?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is the difference between STOP and ABORT options in Workflow Monitor?
