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 active and passive transforamtions?

2 7585

What are the connected or unconnected transforamations?

2 7141

How many ways you create ports?

1 6066

What are the reusable transforamtions?

2 6243

What are the methods for creating reusable transforamtions?

2 6225

What are the unsupported repository objects for a mapplet?

Informatica,

1 9020

What are the mapping paramaters and mapping variables?

1 6004

Can yoU use the maping parameters or variables created in one maping into another maping?

2 7321

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 5800

How can yoU improve session performance in aggregator transformation?

TCS,

8 27729

What are the diffrences between joiner transformation and source qualifier transformation?

2 17328

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 10819

what are the settiings that u use to cofigure the joiner transformation?

2 6658

What are the join types in joiner transformation?

Informatica,

1 6491

What are the joiner caches?

Informatica,

3 17753

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7457

What are the components of Informatica? And what is the purpose of each?

1056

What is persistent lookup cache?

1035

What is the use of an aggregator cache file?

1200

What is the Process to creating lookup transformation in informatica

1046

State the limitations where we cannot use joiner in the mapping pipeline?

1068

Why union transformation is an active transformation?

1049

Slowly changing dimensions, types and where will you use them

1717

Enlist the various types of transformations.

1060

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2400

Explain how to import oracle sequence into informatica?

1020

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2554

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2134

What is the difference between STOP and ABORT options in Workflow Monitor?

1258

How to start a workflow using pmcmd command?

1256

For More Un-Answered { Informatica } Questions Click Here