Informatica Interview Question and Answers
| 51. |
What are different types of parsing? |
| |
- Quick parsing
- Thorough parsing
|
| |
|
| 52. |
What are Lookup and Fact Tables? |
| |
A lookup (Dimension) table contains information about the entities. In general the Dimension and details objects are derived from lookup tables. A fact table contains the statistical information about transactions. |
| |
|
| 53. |
What is Designer? |
| |
Designer is the Business objects product that is intended to develop the universes. These universe is the semantic - layer of the database structure that isolates from technical issues. |
| |
|
| 54. |
What is Surrogate Key? |
| |
Surrogate keys are keys that are maintained within the data warehouse instead of keys taken from source data systems. |
| |
|
| 55. |
What are the pitfalls of DWH? |
| |
- Limited value of data (Historical data not current data)
- DW solutions complicate business processes
- DW solutions may have too long a learning curve
- Costs of cleaning, capturing and delivering data
|
| |
|
Gk Questions with Answers