Informatica Interview Questions
Questions Answers Views Company eMail

disable caching in a lookup transformation?

1 1816

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

1 2246

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

1 1968

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

1 1947

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

1 2121

How big was your fact table

1302

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 2254

How will you convert rows into columns or columns into rows

1 2017

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

1569

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

1668

What are the new features of Power Center 5.0?

1220

How to run a session, which contains mapplet?

1 3279

Differentiate between Load Manager and DTM?

1652

What are session parameters ? How do you set them?

1363

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

1 3325


Post New Informatica Questions

Un-Answered Questions { Informatica }

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

769


Different sorts of metadata that stores in the storage facility?

545


explan ur project architecture?

1583


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1683


What is option by which we can run all the sessions in a batch simultaneously?

652






Describe data concatenation?

560


What is union transformation in informatica?

686


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1743


What is the format of informatica objects in a repository?

591


what is mean by complex business rule ?

1710


how to load rows into fact table in data warehouse

627


What are the new features of informatica 9.x developer?

524


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

795


How identifying bottlenecks in various components of informatica and resolving them?

571


What all join we can perform in LOOKUP transformation?

548