0 Source In Informatica

Sources are table definitions imported from a database into the

PowerCenter repository. These table definitions are used while developing mappings to define the attributes to read from. Once imported, the

table definitions remain independent of the underlying database. Hence, if a

table definition in the source database changes, it needs to be re-imported

again. Sources are stored within folders. Thus, a source can be imported into

multiple folders. In which case, each definition is unique and must be

maintained separately. Sources can be grouped into data sources. They must be

unique within a data source. So, within a given data source in a given folder,

there can be only one source having a certain name. Developers can organize

the sources into different data sources as they see fit. However, each source

definition can be associated with only one data source. The same data source

can be imported into PowerCenter repository under different data sources. For

example, a source table "employees" can exist in data sources "Data

Warehouse" and "Data Mart". These two table definitions need not be

identical. But "Data Warehouse" data source itself cannot have two tables of

the name "employee".