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 2463

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

1 2977

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

1 2770

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

1 2704

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

1 2857

How big was your fact table

1803

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 3513

How will you convert rows into columns or columns into rows

1 2685

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

2109

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

2112

What are the new features of Power Center 5.0?

1779

How to run a session, which contains mapplet?

1 3998

Differentiate between Load Manager and DTM?

2154

What are session parameters ? How do you set them?

1850

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

1 4043

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the reusable transformation?

1047

How to improve the performance of a session using sorter transformation?

1146

Which version configuration tool used in ur project?

3260

How can we delete duplicate rows from flat files?

1223

generate date / time dimension in informatica

1125

Explain about Informatica server process that how it works relates to mapping variables?

1080

Explain the features of connected and unconnected lookup.

935

How can informatica be used for an organization?

1220

Enterprise data warehouse your projects phase by phase explain?

1921

what is informatica metadata?

1037

Separate from a database, an information bazaar, and an information stockroom?

1089

What are the transformations that are not supported in mapplet?

1032

What are the new features of Power Center 5.0?

1779

Why do we need informatica?

994

How to create Target definition for flat files?

1227

For More Un-Answered { Informatica } Questions Click Here