Informatica Interview Questions
Questions Answers Views Company eMail

disable caching in a lookup transformation?

1 1819

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

1 2248

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

1 1973

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

1 1949

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

1 2123

How big was your fact table

1303

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 2260

How will you convert rows into columns or columns into rows

1 2019

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

1572

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

1669

What are the new features of Power Center 5.0?

1223

How to run a session, which contains mapplet?

1 3281

Differentiate between Load Manager and DTM?

1654

What are session parameters ? How do you set them?

1364

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

1 3331


Post New Informatica Questions

Un-Answered Questions { Informatica }

Is it possible to use a client with different version than that of its Informatica server?

632


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1224


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

679


Explain the informatica workflow?

577


How might you approve all mappings in the archive all the while?

593






Which transformation is needed while using the Cobol sources as source definitions?

717


Briefly define a session task?

583


How to update source definition?

620


What are the modules in Power Center

1216


Differentiate between sessions and batches?

563


Can we get 1st record through Informatica(without sequence number).

970


How to extract sap data using informatica?

595


What all are steps in up gradation of Informatica server?

612


How to join three sources using joiner?

558


What is complex mapping?

628