Informatica Interview Questions

Diff between Informatica repositry server & Informatica server

How can we partition a session in Informatica?

What is code page compatibility?

Compatibility between code pages is used for accurate data movement when the Informatica sever runs in the unicode data movement mode. If the code pages are identical, then there will not be any data loss. One code page can be a subset or superset of another. For accurate data movement, the target code...

What r the rank caches?

During the session ,the Informatica server compares an inout row with rows in the datacache.If the input row out-ranks a stored row,the Informatica server replaces the stored row with the input row.The Informatica server stores group information in an index cache and row data in a data cache.

What is the status code?

Status code provides error handling for the Informatica server during the session.The stored procedure issues a status code that notifies whether or not stored procedure completed sucessfully.This value can not seen by the user.It only used by the Informatica server to determine whether to continue running...

Describe two levels in which update strategy transformation sets?

Within a session. When you configure a session, you can instruct the Informatica server to EIther treat all records in the same way (for example, treat all records as inserts), or use instructions coded into the session mapping to flag records for different database operations. Within a mapping. Within...

What r the new features of the server manager in the Informatica 5.0?

U can use command line arguments for a session or batch.This allows u to change the values of session parameters,and mapping parameters and maping variables. Parallel data processing: this feature is available for powercenter only.If we use the Informatica server on a smp system,u can use multiple cpu’s...

What is metadata reporter?

It is a web based application that enables you to run reports againist repository metadata. With a meta data reporter,u can access information about u’r repository with out having knowledge of SQL,transformation language or underlying tables in the repository.

To achieve the session partition what r the necessary tasks u have to do?

Configure the session to partition source data. Install the Informatica server on a machine with multiple cpu’s.

Why u use repository connectivity?

When u edit,schedule the sesion each time,Informatica server directly communicates the repository to check whether or not the session and users r valid.All the metadata of sessions and mappings will be stored in repository.

What r the out put files that the Informatica server creates during the session running?

Informatica server log: Informatica server(on UNIX) creates a log for all status and error messages(default name: pm.Server.Log).It also creates an error log for error messages.These files will be created in Informatica home directory. Session log file: Informatica server creates session log file for...

What is polling?

It displays the updated information about the session in the monitor window. The monitor window displays the status of each session when u poll the Informatica server

How can u access the remote source into u’r session?

Relational source: to acess relational source which is situated in a remote place ,u need to configure database connection to the datasource. Filesource : to access the remote source file u must configure the ftp connection to the host machine before u create the session. Hetrogenous : when u’r maping...

What r the transformations that restricts the partitioning of sessions?

Advanced external procedure tranformation and external procedure transformation: this transformation contains a check box on the properties tab to allow partitioning. Aggregator transformation: if u use sorted ports u can not parttion the assosiated source joiner transformation : u can not partition...

What r the new features in Informatica 5.0?

U can debug u’r maping in maping designer u can view the work space over the entire screen the designer displays a new icon for a invalid mapings in the navigator window u can use a dynamic lookup cache in a lokup transformation create maping parameters or maping variables in a maping or maplet to make...

What is incremantal aggregation?

When using incremental aggregation, you apply captured changes in the source to aggregate calculations in a session. If the source changes only incremenTALLY and you can capture changes, you can configure the session to process only those changes. This allows the Informatica server to update your target...

What r the scheduling options to run a sesion?

U can shedule a session to run at a given time or intervel,or u can manually run the session. Different options of scheduling run only on demand: server runs the session only when user starts session explicitly run once: Informatica server runs the session only once at a specified date and time. Run...

What is difference between stored procedure transformation and external procedure transformation?

In case of storedprocedure transformation procedure will be compiled and executed in a relational data source.U need data base connection to import the stored procedure in to u’r maping.Where as in external procedure transformation procedure or function will be executed out side of data source.Ie u need...

Explain about recovering sessions?

If you stop a session or if an error causes a session to stop, refer to the session and error logs to determine the cause of failure. Correct the errors, and then complete the session. The method you use to complete the session depends on the properties of the mapping, session, and Informatica server...

Explain about perform recovery?

When the Informatica server starts a recovery session, it reads the opb_srvr_recovery table and notes the row id of the last row committed to the target database. The Informatica server then reads all sources again and starts processing from the next row id. For example, if the Informatica server commits...