Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 14040

what is the architecture of any Data warehousing project?

IBM,

5 18580

what is the flow?

1 6985

How to load time dimension?

Ford,

1 14469

In update strategy target table or flat file which gives more performance ? why?

7 23545

How do you create single lookup transformation using multiple tables?

TCS,

6 41473

Why touse stored procedure in ETL Application?

2 10366

How to improve the performance of Aggregate transformation?

Dmss,

3 12478

What is critical mapping?

2 9994

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

Accenture,

1 18595

How to view and Generate Metadata Reports?

1 6808

what is difference between COM & DCOM?

Satyam,

1 10198

what is the gap analysis?

1 8185

How to recover sessions in concurrent batches?

3 14144

what are the different types of transformation available in informatica and what are the mostly used ?

TCS,

3 23686


Post New Informatica Questions

Un-Answered Questions { Informatica }

How many ways are there to do 'remove duplicate records in informatica'?

574


What is union transformation?

560


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1639


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

622


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3492






explain abt ur project architecture?

1749


What is informatica metadata and where is it stored?

572


Suppose we do not group by on any ports of the aggregator what will be the output?

561


How many ways are there to create ports?

707


What is a rank transform?

664


How can a transformation be made reusable?

654


What are session parameters ? How do you set them?

1363


What is joiner transformation in informatica?

612


Differentiate between joiner and lookup transformation?

603


in reporting we add some new objects,how we get the count of the newly added objects to the report

1737