Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

What are the types of maping in Getting Started Wizard?

1 5735

What are the different types of Type2 dimension maping?

CTS,

2 10384

Can you generate reports in Informatcia?

1 5771

Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 4847

Explain about the concept of mapping parameters and variables ?

HCL, TCS,

3 13299

what is mystery dimension?

1 5901

what are cost based and rule based approaches and what is the difference?

1 5461

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 8047

what is the difference between stop and abort?

TCS,

3 16568

What is Micro Strategy? Why is it used for?

Infosys,

5 25484

what is the difference between Informatica 7.1 and Abinitio?

TCS,

1 9434

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 7138

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 5405

what are the real time problems generally come up while doing or running mapping or any transformation?

2 7042

Explain one complecated mapping?

Fidelity, Wipro,

3 15104

Post New Informatica Questions

Un-Answered Questions { Informatica }

Parameter and variable differences

2060

Briefly describe lookup transformation?

1046

What can we do to improve the performance of informatica aggregator transformation?

1093

What are the static cache and dynamic cache in informatica?

1192

what is INFORMATICA TESTING process

2289

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2035

How identifying bottlenecks in various components of informatica and resolving them?

1132

How do you migrate data from one environment to another?

1095

Is there any target staging area in informatica not staging area

2578

What are the data movement modes in informatica?

1152

wat are deployement groups in informatica, how it will be used for developers

1719

What is the use of an aggregator cache file?

1199

Why update strategy and union transformations are active?

1042

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4160

Enlist some properties of sessions.

1067

For More Un-Answered { Informatica } Questions Click Here