Informatica Interview Question and Answers

33. What are the three important fundamental themes in a data warehouse?
  There are three most important fundamental themes are
  • Drilling Down
  • Drilling Across and
  • Handling Time
 
Your Name Your Email-ID
Your Answer
34. What are the windows of Repository Manager?
 
  • Navigator window
  • Main window
  • Dependency window and
  • Output window
 
Your Name Your Email-ID
Your Answer
35. What types of data sources does Data Warehouse Center support?
  The Data Warehouse Center supports a wide variety of relational and non relational data sources. You can populate your Data Warehouse Center warehouse with data from the following databases and files:
  • Any DB2 family database
  • Oracle
  • Sybase
  • Informix
  • Microsoft SQL Server
  • IBM DataJoiner
  • Multiple Virtual Storage (OS/390),
  • Virtual Machine (VM), and
  • local area network (LAN) files
  • IMS and Virtual Storage Access Method (VSAM) (with Data Joiner Classic Connect)
 
Your Name Your Email-ID
Your Answer
36. What is a code page?
 
  • A code page contains encoding to specify characters in a set of one or more languages. The code page is selected based on source of the data. For example if source contains Japanese text then the code page should be selected to support Japanese text.
  • When a code page is chosen, the program or application for which the code page is set, refers to a specific set of data that describes the characters the application recognizes. This influences the way that application stores, receives, and sends character data.
 
Your Name Your Email-ID
Your Answer
123456789101112


131415 Page 9 of 15