Informatica INTERVIEW QUESTION & ANSWERS
| 41. |
What is Rolap? |
| |
Relational OLAP (ROLAP) servers store data in relational databases and support extensions to SQL and special access methods to efficiently implement the multidimensional data model and the related operations. |
| 42. |
What is Molap? |
| |
Multidimensional OLAP (MOLAP) servers directly store multidimensional data in special data structures (for instance, arrays) and implement the OLAP operations over those data structures. While MOLAP systems offer less storage capacity than ROLAP systems, MOLAP systems provide better performance when multidimensional data is queried or aggregated. |
| 43. |
What is Holap? |
| |
Hybrid OLAP (HOLAP) servers combine both technologies, benefiting from the storage capacity of ROLAP and the processing capabilities of MOLAP. |
| 44. |
Describe 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. |
| 45. |
What is fact? |
| |
A central component of a multidimensional model that contains the measures to be analyzed. Facts are related to dimensions. |
