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 9817

What are the new features of informatica 7.1?

2 7360

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

NIIT,

1 10043

What is the functionality of update strategy?

2 9245

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

1 13607

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

7 15863

What are limitations of joiner transformation?

Exilant, TCS,

2 21215

can we generate reports in informatica ? How?

3 21844

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

2 7317

How can we eliminate duplicate rows from flatfile,explain?

3 11835

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 7255

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

Cap Gemini, Cognizant,

1 17292

What are slowly changing dimensions?

Informatica, Verinon Technology Solutions,

5 30817

What is the difference between OLTP and ODS?

4 27775

What is status code?

2 7112

Post New Informatica Questions

Un-Answered Questions { Informatica }

How you prepared reports for OLAP?

1594

How can you define user defied event?

1025

How can a transformation be made reusable?

1159

What are the databases that informatica can connect to windows?

1044

How to create a non-reusable instance of reusable transformations?

1115

Mention a few design and development best practices for informatica?

992

Explain dynamic target flat file name generation in informatica

1045

How to create Target definition for flat files?

1211

What is flashback table ? Advance thanks

1928

What is the use of source qualifier?

1120

Is stop and abort are same in informatica?

995

Explain sessions. Explain how batches are used to combine executions?

1024

Explain joiner transformation in informatica

1123

What is workflow monitor?

1055

Which development components of informatica have the highest usage?

1031

For More Un-Answered { Informatica } Questions Click Here