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

Informatica Interview Questions

Questions Answers Views Company eMail

If we are using an aggregator but forget to mention the group by port .what will be the output??

Nomura, TCS,

11 34641

I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 10937

can we create index and drop index in exsisting table while using infomatica

4 20184

"Change cache" in Informatica ?

2 7740

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 16180

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 19526

how we do performence tuning in informatica

3 8078

Diff b/w ShortCut and reusabel Object ?

4 8632

What are the ETL tools available in DWH?

Mphasis,

6 15500

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

iGate,

5 12088

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

iGate,

1 7027

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 8283

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

TCS,

3 10726

Router T/R is active but some people are saying it is also passive which is exactly right?

5 20632

how to convert the .doc docs into .txt format using informatica

4 12606

Post New Informatica Questions

Un-Answered Questions { Informatica }

wf dont have integration severances how you can run?

1990

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

1174

What are session parameters ? How do you set them?

1901

What is a joiner transformation?

1037

How to load data in informatica ?

1070

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2350

Scheduling properties,whats the default (sequential)

2014

What is informatica metadata and where is it stored?

1047

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1734

What is informatica? Why do we need it?

1166

What are the types of caches in lookup? Explain them.

1015

How to delete duplicate row using informatica?

1092

What is enterprise data warehousing?

1107

What are the new features of informatica 9.x developer?

1034

What are the uses of etl tools?

1179

For More Un-Answered { Informatica } Questions Click Here