Informatica Interview Question and Answers

1. Explain Informatica Architecture?
  • Informatica consist of client and server.
  • Client tools such as Repository manager, Designer, Server manager.
  • Repository data base contains metadata it read by informatica server used read data from source, transforming and loading into target.
Your Name Your Email-ID
Your Answer
2. What type of repositories can be created using Informatica Repository Manager?
  Informatica PowerCenter includeds following type of repositories
  • Standalone Repository : A repository that functions individually and this is unrelated to any other repositories.
  • Global Repository : This is a centralized repository in a domain. This repository can contain shared objects across the repositories in a domain. The objects are shared through global shortcuts.
  • Local Repository : Local repository is within a domain and it's not a global repository. Local repository can connect to a global repository using global shortcuts and can use objects in it's shared folders.
  • Versioned Repository : This can either be local or global repository but it allows version control for the repository. A versioned repository can store multiple copies, or versions of an object. This features allows to efficiently develop, test and deploy metadata in the production environment.
Your Name Your Email-ID
Your Answer
3. Explain the DataWarehousing life cycle?
  Data warehouses can have many different types of life cycles with independent data marts. The following is an example of a data warehouse life cycle. In the life cycle of this example, four important steps are involved.
  • Extraction - As a first step, heterogeneous data from different online transaction processing systems is extracted. This data becomes the data source for the data warehouse.
  • Cleansing/transformation - The source data is sent into the populating systems where the data is cleansed, integrated, consolidated, secured and stored in the corporate or central data warehouse.
  • Distribution - From the central data warehouse, data is distributed to independent data marts specifically designed for the end user.
  • Analysis - From these data marts, data is sent to the end users who access the data stored in the data mart depending upon their requirement.
Your Name Your Email-ID
Your Answer
4. What is the difference between OLTP and OLAP?
  • OLAP - Online Analytical processing, mainly required for DSS, data is in denormalized manner and mainly used for non volatile data, highly indexed, improve query response time.
  • OLTP - Transactional Processing - DML, highly normalized to reduce deadlock & increase concurrency.
Your Name Your Email-ID
Your Answer

131415 Page 1 of 15