Informatica Interview Question and Answers

29. What is the functionality of Repository server administration console?
  Repository server administration console is used to create and administer the repository through the repository server.
 
Your Name Your Email-ID
Your Answer
30. What are different types of Dimensional Modeling?
 
  • Dimensional - Star Schema(central table fact table with numeric data , all others are linked to central table, faster , but denormalised)
  • Snowflake Schema(one fact table, Normalizing the dimension tables. Fact Constellation(Different fact tables and combined from one datamart to other).
 
Your Name Your Email-ID
Your Answer
31. What is Metadata?
  Metadata is defined as the data about data. Metadata describes the entity and attribute description. The description of the source data, target data and the transformations carried out is stored in a separate database (or repository) called metadata repository.
 
Your Name Your Email-ID
Your Answer
32. What are the various Designer windows?
 
  • Navigator
  • Workspace
  • Status Bar
  • Output
  • Overview
  • Instance Data
  • Target Data
 
Your Name Your Email-ID
Your Answer
123456789101112


131415 Page 8 of 15