What are the different types of Type2 dimension maping?
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 to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
In informatica workflow manager, how many repositories can be created?
What is DR strategy for Informatica project?
What are the measure objects?
What is incremental aggregation?
What are the reusable transformations?
Repository user profiles
if we have a delimiters at unwanted places in a flat file how can we over come those.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is the difference between stop and abort in informatica
How do you convert single row from source into three rows into target?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the surrogate key?
Explain the different dimensions.
Define Pmrep command?