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 5723

What are the different types of Type2 dimension maping?

CTS,

2 10371

Can you generate reports in Informatcia?

1 5763

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

1 4836

Explain about the concept of mapping parameters and variables ?

HCL, TCS,

3 13283

what is mystery dimension?

1 5901

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

1 5453

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

2 8034

what is the difference between stop and abort?

TCS,

3 16556

What is Micro Strategy? Why is it used for?

Infosys,

5 25454

what is the difference between Informatica 7.1 and Abinitio?

TCS,

1 9426

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

3 7121

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

1 5395

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

2 7028

Explain one complecated mapping?

Fidelity, Wipro,

3 15091

Post New Informatica Questions

Un-Answered Questions { Informatica }

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2121

What are the guidelines to be followed while using union transformation?

1134

What is different between the data warehouse and data mart?

1057

difference between repository database and repository service?

1145

How can we use batches?

1022

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1899

What is the different lookup cache(s)?

1081

How big was your fact table

1795

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2049

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2316

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4105

What is a passive transformation?

1099

can we override a native sql query within informatica? How do we do it?

1121

what is mean by complex business rule ?

2154

What is depict expression change?

1111

For More Un-Answered { Informatica } Questions Click Here