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 5772

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 13304

what is mystery dimension?

1 5902

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

1 5463

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 16569

What is Micro Strategy? Why is it used for?

Infosys,

5 25490

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 7139

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

1 5406

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

2 7045

Explain one complecated mapping?

Fidelity, Wipro,

3 15105

Post New Informatica Questions

Un-Answered Questions { Informatica }

How can we use mapping variables in informatica?

1063

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2035

Which version configuration tool used in ur project?

3258

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1109

What are the differences between oltp and olap?

972

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2199

Explain the features of connected and unconnected lookup.

935

How to do unit testing in informatica? How to load data in informatica ?

1120

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5791

Explain the difference between a data warehouse and a data mart?

1056

What are session parameters ? How do you set them?

1850

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1049

What is a surrogate key?

1080

How might you approve all mappings in the archive all the while?

1018

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7186

For More Un-Answered { Informatica } Questions Click Here