Answer Posted / rekha
SCD IS SLOWLY CHANGING DIMENSION
SLOWLY CHANGING DIMENSIONS ARE DIMNESION TABLES WITH SLOWLY
INCREASING DATA AS WELL AS UPDATES TO THE EXISTING DATA
THERE ARE THREE TYPES OF DIMENSIONS
TYPE 1
TYP2 - VERION ,FLAG ,EFFECTIVE
TYPE3
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Write the prerequisite tasks to achieve the session partition?
What does refresh system mean, and what are its distinctive choice?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is a shortcut and copy in Informatica and how two are different with each other?
What do mean by local and global repository?
What is lookup change?
What is a pre-defined event and user-defined event?
Explain why we use partitioning the session in informatica?
What are the new features of informatica 9.x in developer level?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to use pmcmd utility command?
What is an expression transformation in informatica?
What are mapplets? How is it different from a Reusable Transformation?
What does command task mean?
What is domain in terms of informatica?