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 5667

What are the different types of Type2 dimension maping?

CTS,

2 10271

Can you generate reports in Informatcia?

1 5703

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

1 4773

Explain about the concept of mapping parameters and variables ?

HCL, TCS,

3 13158

what is mystery dimension?

1 5850

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

1 5383

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

2 7956

what is the difference between stop and abort?

TCS,

3 16436

What is Micro Strategy? Why is it used for?

Infosys,

5 25181

what is the difference between Informatica 7.1 and Abinitio?

TCS,

1 9370

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

3 7013

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

1 5345

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

2 6935

Explain one complecated mapping?

Fidelity, Wipro,

3 14998

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain the shared cache and re-cache?

1067

What are multi-group transformations?

1031

Why filter transformation is an active one?

941

How an expression transformation differs from aggregator transformation?

1000

What is status code in informatica?

972

What is an aggregator transformation?

1040

How can we delete duplicate rows from flat files?

1179

Can we create two repositories on same database instance in oracle?

1042

What are the mapping parameters and mapping variables?

1109

Explain pmcmd command usage in informatica

1079

Which are the different editions of informatica powercenter that are available?

990

Separate from an archive server and a powerhouse?

917

How to generate or load values in to the target table based on a column value using informatica etl tool.

1035

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2106

What is target designer and target load order?

1057

For More Un-Answered { Informatica } Questions Click Here