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

Informatica Interview Questions

Questions Answers Views Company eMail

what r the transformations that r not involved in mapplet?

Wipro,

8 31611

what is data driven?

TCS, Wipro,

5 53744

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 9841

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

TCS,

5 25079

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 11625

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

Target,

9 20275

two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

TCS,

2 10105

HOW TO GET THE LATEST DATA IN SCD ?

TCS,

4 21527

what is the function of 'F10' informatica ?

IBM,

4 15459

suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

TCS,

3 10501

what are the reusable tasks in informatica ?

CTS, HP, IBM, TCS,

11 54007

HOW DO YOU PARFORM INCREMENTAL LAOD ?

SAIC,

7 16414

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

Oracle,

4 13529

HOW DO YOU CONNECT TO REMOTE SERVER ?

Patni, TCS,

1 8510

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

Target,

7 34229

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the difference between router and filter?

1169

can u give example for factless fact table

6461

How do you promote a non-reusable transformation to reusable transformation?

1078

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2002

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2300

What are session parameters ? How do you set them?

1780

Explain the types of lookup transformation?

984

what is the size of your data warehousing?

2052

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2107

whats the logic to load the lower level of granularity of data to fact table.

2217

can we override a native sql query within informatica? Where do we do it?

1077

How do you load only null records into target? Explain through mapping flow.

1965

explain about unit testing? in real time?

2143

What is DR strategy for Informatica project?

1122

What does reusable transformation mean?

1083

For More Un-Answered { Informatica } Questions Click Here