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 7423

What are the connected or unconnected transforamations?

2 7001

How many ways you create ports?

1 5986

What are the reusable transforamtions?

2 6107

What are the methods for creating reusable transforamtions?

2 6113

What are the unsupported repository objects for a mapplet?

Informatica,

1 8922

What are the mapping paramaters and mapping variables?

1 5918

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

2 7124

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

1 5700

How can yoU improve session performance in aggregator transformation?

TCS,

8 27354

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

2 17186

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

2 10698

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

2 6506

What are the join types in joiner transformation?

Informatica,

1 6378

What are the joiner caches?

Informatica,

3 17612

Post New Informatica Questions

Un-Answered Questions { Informatica }

How we can create indexes after completing the load process?

1117

can anyone explain me about retail domain project in informatica?

7895

What is a difference between complete, stop and abort?

1038

How to delete duplicate row using informatica?

988

How to join three sources using joiner?

1040

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2063

What are multi-group transformations?

1015

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1734

Explain joiner transformation in informatica

1080

What is the function of aggregator transformation?

1026

define galaxy repository in informatica

2164

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1932

Explain in detail scd type 2 through mapping.

997

Tell me about Propagate functions in informatica

880

Define joiner transformation?

992

For More Un-Answered { Informatica } Questions Click Here