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 9913

What are the new features of informatica 7.1?

2 7479

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

NIIT,

1 10123

What is the functionality of update strategy?

2 9368

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

1 13698

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

7 16136

What are limitations of joiner transformation?

Exilant, TCS,

2 21327

can we generate reports in informatica ? How?

3 22046

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

2 7458

How can we eliminate duplicate rows from flatfile,explain?

3 12013

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 7400

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

Cap Gemini, Cognizant,

1 17388

What are slowly changing dimensions?

Informatica, Verinon Technology Solutions,

5 31072

What is the difference between OLTP and ODS?

4 28008

What is status code?

2 7253

Post New Informatica Questions

Un-Answered Questions { Informatica }

can anyone suggest best free Talend data integration training online

1745

What is the sequence generator transformation in informatica?

1267

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

1115

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2132

What are the different clients of powercenter?

1118

In development project what is the process to follow for an etl developer from day1

1760

Explain the use of aggregator cache file?

1322

How can you differentiate between powercenter and power map?

1144

How to update or delete the rows in a target, which do not have key fields?

1226

What is informatica metadata and where is it stored?

1047

Explain Dataware house architecture .how data flow from intial to end?

2652

Differences between connected and unconnected lookup?

1273

Write the advantages of partitioning a session?

1337

Define enterprise data warehousing?

1257

What are the different transaction levels available in transaction control transformation?

1279

For More Un-Answered { Informatica } Questions Click Here