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 2392

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

1 2896

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

1 2704

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

1 2608

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

1 2752

How big was your fact table

1756

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 3436

How will you convert rows into columns or columns into rows

1 2616

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

2056

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

2063

What are the new features of Power Center 5.0?

1712

How to run a session, which contains mapplet?

1 3917

Differentiate between Load Manager and DTM?

2098

What are session parameters ? How do you set them?

1785

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

1 3974

Post New Informatica Questions

Un-Answered Questions { Informatica }

Write the different tools in the workflow manager?

1005

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2009

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2278

On which transformations you created partitions in your project?

1269

How can a transformation be made reusable?

1089

What are the designer tools for creating transformations?

1056

Implementation methodology

1659

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1855

Clarify the utilization of aggregator cache record?

956

is it possible to index the data in cache of lkp transformation ?

1972

What is a filter transformation?

997

What is the status code in stored procedure transformation?

1131

What is a rank transform?

1040

Is it possible to create multiple domains on a single Informatica server?

1191

What all are steps in up gradation of Informatica server?

1001

For More Un-Answered { Informatica } Questions Click Here