Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 14897

what is the architecture of any Data warehousing project?

IBM,

5 19303

what is the flow?

1 7467

How to load time dimension?

Ford,

1 14835

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

7 24443

How do you create single lookup transformation using multiple tables?

TCS,

6 42482

Why touse stored procedure in ETL Application?

2 10765

How to improve the performance of Aggregate transformation?

Dmss,

3 13017

What is critical mapping?

2 10448

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

Accenture,

1 19036

How to view and Generate Metadata Reports?

1 7079

what is difference between COM & DCOM?

Satyam,

1 10474

what is the gap analysis?

1 8581

How to recover sessions in concurrent batches?

3 14555

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

TCS,

3 24165


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is meant by query override?

767


How we can create indexes after completing the loan process?

873


What is the cumulative sum and moving sum?

894


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1645


What is meant by incremental aggregation?

695






What do you mean by blocking transformation?

711


Mention few advantages of router transformation over filter transformation.

768


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

6713


Explain sql transformation in script mode examples in informatica

721


How can we use mapping variables in informatica?

720


server hot-ws270 is connect to Repository B. What does it mean?

2020


How an expression transformation differs from aggregator transformation?

739


how many types of dimensions are available in informatica?

677


Can we change Dynamic to Static or Persistent cache? If so what happens?

1851


What is the way to execute pl/sql script using informatica mapping?

1119