What are Dimensions and various types of Dimensions?
Answer Posted / vvm.sp
Subject of the mesurable data. Dimensions are mainly 11
types. They are
1. Changing Dimension
2. Slowly Changing Dimension
3. Rapidly Changing Dimension
4. Conformed Dimension
5. Degenerate Dimension
6. Junk Dimension
7. Inferred Dimension
8. Role Playing Dimension
9. Shrunken Dimension
10. Out Triggers
11. Static Dimension
| Is This Answer Correct ? | 46 Yes | 13 No |
Post New Answer View All Answers
Define enterprise data warehousing?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are Dimensional table?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is an unconnected transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
how to create user defined function (udf) in informatica
what is index?how it can work in informatica
What is meant by pre and post session shell command?
What all join we can perform in LOOKUP transformation?
What is Session and Batches?
What are the restrictions of union transformation?
What will be the approach?
How can we delete duplicate rows from flat files?