Informatica interview questions and answers part 6

Part1[1-7]  Part2[8-14]  Part3[15-23]  Part4[24-30]  Part5[31-37]  Part6[38-44]
Part7[45-51]

38.What are Stored Procedure transformation?

Ans- Stored Procedure transformation is an Passive & Connected or UnConnected transformation. It is useful to automate time-consuming tasks and in error handling, to drop and recreate indexes.

39. What is a source qualifier?

Ans- Source Qualifier represents the rows that the PowerCenter Server reads from a relational or flat file source when it runs a session. 

40. How a transformation be defined?
Ans-  A transformation is a repository object that generates, modifies, and passes data. The Designer provides a set of transformations that perform specific functions 

41. What are different types of transformations available in Informatica?

Ans - Aggregator, Application Source Qualifier, Custom, External Procedure , Expression, Filter, Input, Joiner, Lookup, Normalizer, Output, Rank, Router,  Sequence Generator,  Sorter, Stored Procedure , Source Qualifier ,   Transaction Control,    Update Strategy,  Union,  XML Source Qualifier ,  XML Generator,  XML Parser

42.What is Surrogate Key?
Ans - Surrogate key is a key that is maintained within the data warehouse instead of key taken from source data systems.

43. What are the types of OLAP?

Ans - 1. ROLAP (Relational OLAP) 2. MOLAP (Multidimensional OLAP) 3. HOLAP (Hybrid OLAP)

44. What is ROLAP

Ans ROLAP stands for Relational OLAP. Users see their data organised in cubes and dimensions but the data is stored in RDBMS.

Part1[1-7]  Part2[8-14]  Part3[15-23]  Part4[24-30]  Part5[31-37]  Part6[38-44]
Part7[45-51]