Informatica INTERVIEW QUESTION & ANSWERS
| 31. |
What is Datadriven? |
| |
The informatica server follows instructions coded into update strategy transformations with in the session maping determine how to flag records for insert,update,delete or reject. If u do not choose data driven option setting, the informatica server ignores all update strategy transformations in the mapping. |
| 32. |
What are the three major types of metadata in a data warehouse? |
| |
Metadata in a data warehouse fall into three major categories : - Operational Metadata
- Extraction and Transformation Metadata
- End–User Metadata
|
| 33. |
What is OLAP? |
| |
- Allow users to run complex dimensional queries.
- Enable users to generate canned queries.
- Two categories of online analytical processing are multidimensional online analytical processing (MOLAP) and relational online analytical processing (ROLAP).
|
| 34. |
What is meant by geographic information system(GIS)? |
| |
A software system that allows users to define, create, maintain, and control access to a geographic database. |
| 35. |
What is dimension table? |
| |
A relational table that contains dimension data. |
