Category Archives: Informatica Interview Questions

WHAT IS THE DIFFERENCE BETWEEN FILTER AND LOOKUP TRANSFORMATION? | Informatica Questions

1) Filter transformation is an Active transformation and Lookup is a Passive transformation 2) Filter transformation is used to Filter rows based on condition and Lookup is used to to look up data

Posted in Informatica Interview Questions | Leave a comment

WHEN WE CREATE A TARGET AS FLAT FILE AND SOURCE AS ORACLE. HOW CAN I SPECIFY FIRST ROWS AS COLUMN NAMES IN FLAT FILES. | Informatica Questions

Use a pre sql statement….but this is a hardcoding method…if you change the column names or put in extra columns in the flat file, you will have to change the insert statement.

Posted in Informatica Interview Questions | Leave a comment

WHAT IS DIFFERENCE B/W INFORMATICA 7.1 AND ABINITIO | Informatica Questions

There is a lot of diffrence between informatica an Ab Initio In Ab Initio we r using 3 parllalisim but Informatica using 1 parllalisim In Ab Initio no scheduling option we can scheduled manual

Posted in Informatica Interview Questions | Leave a comment

HOW MANY TYPES OF DIMENSIONS ARE AVAILABLE IN INFORMATICA? | Informatica Questions

There r 3 types of dimensions 1.star schema 2.snowflake schema 3.glaxy schema

Posted in Informatica Interview Questions | Leave a comment

IN UPDATE STRATEGY TARGET TABLE OR FLAT FILE WHICH GIVES MORE PERFORMANCE? WHY? | Informatica Questions

Pros: Loading, Sorting, Merging operations will be faster as there is no index concept and Data will be in ASCII mode. Cons: There is no concept of updating existing records in flat file.

Posted in Informatica Interview Questions | Leave a comment

WHAT IS THE DIFFERENCE BETWEEN STOP AND ABORT? | Informatica Questions

stop: _______If the session u want to stop is a part of batch you must stop the batch, if the batch is part of nested batch, Stop the outer most batch Abort:—- You can issue the abort comma.

Posted in Informatica Interview Questions | Leave a comment

HOW CAN YOU IMPROVE SESSION PERFORMANCE IN AGGREGATOR TRANSFORMATION? | Informatica Questions

One way is supplying the sorted input to aggregator transformation. In situations where sorted input cannot be supplied, we need to configure data cache and index cache at session/transformation level.

Posted in Informatica Interview Questions | Leave a comment

HOW CAN YOU CREATE OR IMPORT FLAT FILE DEFINITION IN TO THE WAREHOUSE DESIGNER? | Informatica Questions

You can not create or import flat file defintion in to warehouse designer directly.Instead you must analyze the file in source analyzer,then drag it into the warehouse designer. When you drag the fl

Posted in Informatica Interview Questions | Leave a comment

EXPLAIN ABOUT INFORMATICA SERVER ARCHITECTURE? | Informatica Questions

Informatica server,load manager/rs,data transfer manager,reader,temp server and writer are the components of informatica server. first load manager sends a request to the reader if the reader is ready

Posted in Informatica Interview Questions | Leave a comment

HOW THE INFORMATICA SERVER SORTS THE STRING VALUES IN RANK TRANSFORMATION? | Informatica Questions

When Informatica Server runs in UNICODE data movement mode ,then it uses the sort order configured in session properties.

Posted in Informatica Interview Questions | Leave a comment