Interested to Buy Any Domain ? << Click Here >> for more details...
Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions
- 3 Answers
- 8071 Views
- Infotech, I also Faced
- E-Mail Answers
Answer Posted / raveendra g
One dimension which used more than one cube called
Confirmed dimension.
Junk dimension is nothing but Durty. We have to take
unrelated attributes and data into maintain single table
called junk dimension.
DD: The value of the dimension which is stored in the
factable called Degenerated Dimension
SCD: The value of the dimension is happen to change very
rarely and commonly called SCD.
3 Types of SCDS we are having
SCD1: Only current
SCD2: Current+History, Here we can add rows
SCD3: Current+just recent, Here we can add columns level
data.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are junk dimensions?
Implementation methodology
What is a node in Informatica?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are active transformations.
how we can load rejected record's at run time?(not through bad files)
Clarify the utilization of aggregator cache record?
In informatics server which files are created during the session rums?
How does a sorter cache works?
scenario where i can use only concurrent execution of workflow.
Define update strategy?
What is xml source qualifier transformation in informatica?
Separate from an archive server and a powerhouse?
Which are the different editions of informatica powercenter that are available?
