30 Best Informatica Interview Questions and Answers

List of top 30 most frequently asked informatica interview questions and answers pdf download free

Informatica Interview Questions and Answers List

  1. HOW CAN YOU RECOGNIZE WHETHER OR NOT THE NEWLY ADDED ROWS IN THE SOURCE ARE GETS INSERT IN THE TARGET?
  2. WHAT IS THE DIFFERENCE BETWEEN INFORMATICA 7.0 AND 8.0?
  3. PERFORMANCE TUNING IN INFORMATICA?
  4. DIFFERENCES BETWEEN NORMALIZER AND NORMALIZER TRANSFORMATION.
  5. WHAT IS THE TARGET LOAD ORDER?
  6. DIFF BETWEEN STATIC AND DYNAMIC CACHE? AND PLEASE EXPLAIN WITH ONE EXAMPLE?
  7. WHAT IS THE USE OF INCREMENTAL AGGREGATION? EXPLAIN ME IN BRIEF WITH AN EXAMPLE.
  8. WHAT IS THE DIFFERENCE BETWEEN INFORMATICS 7X AND 8X AND WHAT IS LATEST VERSION?
  9. HOW DO WE DO UNIT TESTING IN INFORMATICA? HOW DO WE LOAD DATA IN INFORMATICA?
  10. IS SORTER AN ACTIVE OR PASSIVE TRANSFORMATION? WHAT HAPPENS IF WE UNCHECK THE DISTINCT OPTION IN SORTER? WILL IT BE UNDER ACTIVE OR PASSIVE TRANSFORMATION?
  11. HOW THE INFORMATICA SERVER SORTS THE STRING VALUES IN RANK TRANSFORMATION?
  12. EXPLAIN ABOUT INFORMATICA SERVER ARCHITECTURE?
  13. HOW CAN YOU CREATE OR IMPORT FLAT FILE DEFINITION IN TO THE WAREHOUSE DESIGNER?
  14. HOW CAN YOU IMPROVE SESSION PERFORMANCE IN AGGREGATOR TRANSFORMATION?
  15. WHAT IS THE DIFFERENCE BETWEEN STOP AND ABORT?
  16. IN UPDATE STRATEGY TARGET TABLE OR FLAT FILE WHICH GIVES MORE PERFORMANCE? WHY?
  17. HOW MANY TYPES OF DIMENSIONS ARE AVAILABLE IN INFORMATICA?
  18. WHAT IS DIFFERENCE B/W INFORMATICA 7.1 AND ABINITIO
  19. WHEN WE CREATE A TARGET AS FLAT FILE AND SOURCE AS ORACLE. HOW CAN I SPECIFY FIRST ROWS AS COLUMN NAMES IN FLAT FILES.
  20. WHAT IS THE DIFFERENCE BETWEEN FILTER AND LOOKUP TRANSFORMATION?

Like This Page...Share on FacebookTweet about this on TwitterPin on PinterestShare on Google+Share on LinkedInShare on RedditShare on StumbleUponShare on TumblrBuffer this pageDigg thisEmail this to someone
This entry was posted in Interview Questions. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *