Informatica Interview Question and Answers

71. What is Dimension Table?
 
    It contains data used to reference data stored in the fact table.
  • Fewer rows
  • Primarily character data
  • One primary key (dimensional key)
  • Updatable data
 
Your Name Your Email-ID
Your Answer
72. What is a database connection?
  A connection is a set of parameters that provides access to an RDBMS. These parameters include system information such as the data account, user identification, and the path to the database. Designer provides three types of connections: secured, shared, and personal.
 
Your Name Your Email-ID
Your Answer
73. What are the parts of Informatica Server?
 
  • Load Manager
  • Data Transformation manager
  • Reader
  • Writer
 
Your Name Your Email-ID
Your Answer
74. What is the functionality of repository manager?
  Repository manager is used to navigate through multiple folders and perform the basic repository tasks.
 
Your Name Your Email-ID
Your Answer
75. What is parameter file?
  Parameter file is to define the values for parameters and variables used in a session. A parameter file is a file created by text editor such as word pad or notepad.
 
Your Name Your Email-ID
Your Answer
12345678910111213


14151617181920 Page 15 of 20