FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

Informatica INTERVIEW QUESTION & ANSWERS

Data Warehousing
Follow Us
 
TAGS
46. What are the types of dimensional table?
 
    There are three types of dimensional table are :
  • Conformed dimensional table
  • Junk dimensional table
  • Degenerate dimensional model
  Posted by Chandrasekhar. (Aug 02, 2014)
 

Types of dimensions:
1) Confirmed dimensions table
2) Slowly changing dimension table
3) Roleplaying dimension table
4) Degenarated dimension table
5) Mini dimension
6) junk dimension table
7) Garbage dimension table
Your Name Your Email-ID
Your Answer
 
47. What are the types of fact table?
 
    There are three types of fact table are :
  • Additive fact
  • Semi additive fact
  • Non additive fact
Your Name Your Email-ID
Your Answer
 
48. What are the types of data mart?
 
    There are two types of data mart are :
  • Dependent data mart
  • Independent data mart
Your Name Your Email-ID
Your Answer
 
49. What is data source view?
  A Data source view (DSV) allows one to define the relational schema that will be used in the analysis services database. This schema is derived from the schemas of the various data sources. Cubes and dimensions are created from data source views rather than directly from data source objects.
Your Name Your Email-ID
Your Answer
 
50. What are the different threads in DTM process?
 
  • Master thread
  • Maping thread
  • Pre and post session threads
  • Reader thread
  • Writer thread
  • Transformation thread
Your Name Your Email-ID
Your Answer