Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 15322

what is the architecture of any Data warehousing project?

IBM,

5 19705

what is the flow?

1 7751

How to load time dimension?

Ford,

1 15050

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

7 24903

How do you create single lookup transformation using multiple tables?

TCS,

6 43118

Why touse stored procedure in ETL Application?

2 10992

How to improve the performance of Aggregate transformation?

Dmss,

3 13324

What is critical mapping?

2 10665

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

Accenture,

1 19262

How to view and Generate Metadata Reports?

1 7260

what is difference between COM & DCOM?

Satyam,

1 10653

what is the gap analysis?

1 8930

How to recover sessions in concurrent batches?

3 14813

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

TCS,

3 24473


Post New Informatica Questions

Un-Answered Questions { Informatica }

How to load data in informatica ?

781


what is index?how it can work in informatica

1835


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

860


What is the difference between stop and abort in informatica

881


What are the basic requirements to join two sources in a source qualifier transformation using default join?

831


Explain the aggregator transformation?

862


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

766


can u any challenge your project?

1807


can you please explain me pre session and post session options?

6960


What is the function of look up transformation?

882


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

1746


If informatica has its scheduler why using third party scheduler?

1028


What are the main issues while working with flat files as source and as targets ?

928


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

2365


What is a shortcut and copy in Informatica and how two are different with each other?

945