| |
GeekInterview.com > Interview Questions > Data Warehousing > Informatica
| Print | |
Question: What r the types of metadata that stores in repository?
Answer:
Following r the types of metadata that stores in the repository
Database connections
Global objects
Mappings
Mapplets
Multidimensional metadata
Reusable transformations
Sessions and batches
Short cuts
Source definitions
Target defintions
Transformations
|
| January 01, 2006 01:40:54 |
#1 |
| Sithu |
Database Expert Member Since: December 2005 Total Comments: 161 |
RE: What r the types of metadata that stores in reposi...
|
| Source definitions. Definitions of database objects (tables, views, synonyms) or files that provide source data. Target definitions. Definitions of database objects or files that contain the target data. Multi-dimensional metadata. Target definitions that are configured as cubes and dimensions. Mappings. A set of source and target definitions along with transformations containing business logic that you build into the transformation. These are the instructions that the Informatica Server uses to transform and move data. Reusable transformations. Transformations that you can use in multiple mappings. Mapplets. A set of transformations that you can use in multiple mappings. Sessions and workflows. Sessions and workflows store information about how and when the Informatica Server moves data. A workflow is a set of instructions that describes how and when to run tasks related to extracting, transforming, and loading data. A session is a type of task that you can put in a workflow. Each session corresponds to a single mapping. Cheers, Sithu |
| |
Back To Question | |
