Answer Posted / venky
There are 10 types of dimensions..
1) Primary Dimensions
2) Secondary Dimensions
3) Degenerate Dimension
4) Conformed Dimension
5) Slowly Changing Dimension
6) Rapidly Changing Small Dimension
7) Large Dimension
8) Rapidly Changing Monster Dimension
9) Junk Dimension
10) Role-playing Dimension
| Is This Answer Correct ? | 20 Yes | 2 No |
Post New Answer View All Answers
What is the difference between junk dimension and degenerated dimension?
What is a source qualifier?
What is a full backup?
Explain how to get the first 100 rows from the flat file into the target?
What is the data type of the surrogate key?
What needs to be done when the database is shutdown?
Can you pass sql queries in filter transformation?
What is data stream and data adaopter. Is it same are different? Explain?
Explain in detail abt measure objects? And what is the use of it? How to create it?
What is an error log table in informatica occurs and how to maintain it in mapping?
What are the various methods of getting incremental records or delta records from the source systems?
What is Star Schema?
Why we use repository connectivity?
Explain what is power center repository?
Do you view contain data?
