What are the types of lookup caches?What is Dynamic lookup Transformation? when we use?

Static, Dynamic, Persistent, Re-cache. 

Dynamic lookup updates cache before writes data into the target, first it will update cache then only it updates target table. Generally we are using it in SCD's. 

Informatica Important Questions?

What are the differences between Connected and Unconnected Lookup?

The differences are illustrated in the below table

Connected Lookup	Unconnected Lookup
Connected lookup participates in dataflow and receives input directly from the pipeline	Unconnected lookup receives input values from the result of a LKP: expression in another transformation
Connected lookup can use both dynamic and static cache	Unconnected Lookup cache can NOT be dynamic
Connected lookup can return more than one column value ( output port )	Unconnected Lookup can return only one column value i.e. output port
Connected lookup caches all lookup columns	Unconnected lookup caches only the lookup output ports in the lookup conditions and the return port
Supports user-defined default values (i.e. value to return when lookup conditions are not satisfied)	Does not support user defined default values

Power Exchange, Power Center, Power mart

PowerCenter===========PowerCenter can have many repositories. It supports the Global Repository and networked local repositories.PowerCenter can connect to all native legacy source systems such as Mainframe, ERP, CRM, EAI (TIBCO, MSMQ, JMQ) High Availability and Load sharing on multiple servers in the grid.Informatica Session level Partioning is available.Informatica Pushdown Optimizer is available.

Informatica Power center & Power mart?

Power Center: It is used by large organizations to handle larger volumes of data. We can configure multiple servers. If one server goes down then it automatically switches on to another server.

Informatica Power center installation in all windows XP,7,8

 How to install Informatica? How to create Repository & Integration Services?

 Before we start the SETUP being run we have some very important settings to be done, 

First we have to create a couple of environment variables on our computer, 

this can be done by right clicking on to My Computer and select ‘Properties’.

Informatica Architecture

Informatica Architecture

Informatica Architecture is divided into two components: 1. Server Components -->Server Components in Informatica are: a. Repository Server b. Informatica Server

What is Informatica & What is Repository in Informatica? What is Informatica Repository?

Repository is a container of information about all the objects and activities done within the tools. It keeps references of remote objects like:Source Data ObjectTarget Data ObjectData Connection etc.

What are Integration Services in Informatica? Informatica Integration Services?

Informatica Integration Services

• Informatica Services does all the real job.