Informatica Interview Question and Answers

61. How does the recovery mode work in informatica?
  In case of load failure an entry is made in OPB_SERV_ENTRY(?) table from where the extent of loading can be determined.
 
Your Name Your Email-ID
Your Answer
62. What is Aggregate Awareness?
  Aggregate awareness is a feature of DESIGNER that makes use of aggregate tables in a database. These are tables that contain pre-calculated data. The purpose of these tables is to enhance the performance of SQL transactions; they are thus used to speed up the execution of queries.
 
Your Name Your Email-ID
Your Answer
63. What is a difference between OLTP and OLAP?
 
    OLTP
  • It focus on day to day transaction.
  • Data Stability
  • Dynamic
  • Highly normalized.
  • Access Frequency High.
    OLAP
  • It focus on future predictions and decisions
  • Static until refreshed
  • Demoralized and replicated data
  • Medium to low.
 
Your Name Your Email-ID
Your Answer
64. When should you use a star schema and when a snowflake schema?
  A star schema is a simplest data warehouse schema. Snowflake schema is similar to the star schema. It normalizes dimension table to save data storage space. It can be used to represent hierarchies of information.
 
Your Name Your Email-ID
Your Answer
65. What parameters can be tweaked to get better performance from a session?
  DTM shared memory, Index cache memory, Data cache memory, by indexing, using persistent cache, increasing commit interval etc.
 
Your Name Your Email-ID
Your Answer