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

Informatica Interview Questions

Questions Answers Views Company eMail

Explain the flow of data in Iinformatica?

1 9732

What are the new features of informatica 7.1?

2 7243

What are teh different tasks that can be created in workflow manager?

NIIT,

1 9970

What is the functionality of update strategy?

2 9122

Name 4 output files that informatica server creates during session running?

1 13532

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 15644

What are limitations of joiner transformation?

Exilant, TCS,

2 21109

can we generate reports in informatica ? How?

3 21671

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 7217

How can we eliminate duplicate rows from flatfile,explain?

3 11683

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 7143

AT the max how many transformations and mapplets can we use in a mapping ?

Cap Gemini, Cognizant,

1 17208

What are slowly changing dimensions?

Informatica, Verinon Technology Solutions,

5 30600

What is the difference between OLTP and ODS?

4 27577

What is status code?

2 7000

Post New Informatica Questions

Un-Answered Questions { Informatica }

Briefly describe lookup transformation?

985

What is sorter transformation?

984

What is the sql query overwrite in source qualifier in informatica

1031

What differs when we choose the sorted input for aggregator transformation?

974

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

976

What is informatica etl tool?

943

How to call shell scripts from informatica?

940

What is the benefit of partitioning a session?

1107

What is the meaning of decode in informatica?

1077

Explain the shared cache and re-cache?

1053

Write the advantages of partitioning a session?

1212

Differentiate between Load Manager and DTM?

2096

What are roles and groups and benefits of using them?

995

How to create or import flat file definition in to the warehouse designer?

1026

How can you define user defied event?

980

For More Un-Answered { Informatica } Questions Click Here