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 2461

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

1 2973

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

1 2760

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

1 2694

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

1 2847

How big was your fact table

1798

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 3504

How will you convert rows into columns or columns into rows

1 2683

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

2102

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

2109

What are the new features of Power Center 5.0?

1772

How to run a session, which contains mapplet?

1 3993

Differentiate between Load Manager and DTM?

2151

What are session parameters ? How do you set them?

1843

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

1 4041

Post New Informatica Questions

Un-Answered Questions { Informatica }

explain one complex mapping with logic? sales project?

6663

what is the size of u r source(like file or table)?

2268

How do you migrate data from one environment to another?

1092

expain about the tune parameters?

2411

how to load dimension table and fact table. plz tell me the steps.

2092

In informatica workflow manager, how many repositories can be created?

1351

What is sequence generator transformation in informatica?

1072

Differentiate between Load Manager and DTM?

2151

Why union transformation is an active transformation?

1042

Which version configuration tool used in ur project?

3252

How do you load alternate records into different tables through mapping flow?

1850

How to update or delete the rows in a target, which do not have key fields?

1173

What are the advantages of using informatica as an etl tool over teradata?

1018

Explain why we use partitioning the session in informatica?

1086

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1866

For More Un-Answered { Informatica } Questions Click Here