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

Informatica Interview Questions

Questions Answers Views Company eMail

disable caching in a lookup transformation?

1 2467

In any project how many mappings they will use(minimum)?

1 2981

How do you implement unconn. Stored proc. In a mapping?

1 2774

Can you access a repository created in previous version of Informatica?

1 2710

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 2863

How big was your fact table

1805

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 3520

How will you convert rows into columns or columns into rows

1 2692

What are the steps involved in the migration from older version to newer version of Informatica Server?

2113

What are the main features of Oracle 8i with context to datawarehouse?

2115

What are the new features of Power Center 5.0?

1784

How to run a session, which contains mapplet?

1 4009

Differentiate between Load Manager and DTM?

2161

What are session parameters ? How do you set them?

1856

When do you use mapping parameters? (In which transformations)

1 4048

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is dimensional table? Explain the different dimensions.

1175

What is union transformation in informatica?

1151

What is a rank transform?

1092

Explain in detail scd type 2 through mapping.

1050

Explain the difference between a data warehouse and a data mart?

1062

What is joiner change?

1151

What is a filter transformation and why it is an active one?

971

Differences between connected and unconnected lookup?

1224

What are the features of complex mapping?

1162

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

1129

In which transformation you cannot drag ports into it?

1322

Explain the shared cache and re-cache?

1124

can anyone explain me about retail domain project in informatica?

7950

What is incremental aggregation?

1091

What are the prerequisite tasks to achieve the session partition?

1257

For More Un-Answered { Informatica } Questions Click Here