Answer Posted / pallavi
different types of dimension tables are:
1.regular dimensions
2.composite dimension hierarchy
3.range time based
4.conformed dimension
5.junk dimension
6.degenerate dimension
7.role playing dimension
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain what are the various methods of getting incremental records or delta records from the source systems?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
How to export mappings to the production environment?
What are the main steps to build the data warehouse?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
Store (and count) non-fact records?
Explain what is the difference between stop and abort?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
How can we load the time dimension?
How can you import tables from a database?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What are the advantages of raid 1, 1/0, and
Explain can a dimension table contains numeric values?
What is the use of tabular model, tabular sql, tabular reference in real time application?