Friday, October 06, 2006

INFORMATICA - WAREHOUESE DESIGNER ( TARGET DEFINITION)

Second step in Mapping development is to create your targets. A target in a mapping can be a flatfile, RDBMS or XML. From version 6.x onward, informatica support heterogeneous target in mapping. (Version 5.x and before, it supported on homogeneous targets)
Following target definitions can be imported
FLAT FILE:The Warehouse Designer uses the Flat File Wizard to import a target definition from a flat file that exactly matches the structure of the flat file. For more information, see Importing Flat Files.

RELATIONAL TABLE: You can import a relational table to create a target definition that exactly matches the structure of the relational table.

XML FILE: You can import an XML target definition from an XML, DTD, or XML schema file.
Once you add a target definition to the repository, you can use it in a mapping.
Importing a Relational Target Definition
NOTE: Before you can import target definition from RDBMS, create an ODBC connection to the RDBMS.
When you import a target definition from a relational table, the Designer imports the following target details:
1. Target name: The name of the target.
2. Database location: You specify the database location when you import a relational source. You can specify a different location when you edit the target definition in the Warehouse Designer and when you configure a session.
3. Column names: The names of the columns.
4. Datatypes: The Designer imports the native datatype for each column.
5. Key constraints: The constraints in the target definition can be critical, since they may prevent you from moving data into the target if the PowerCenter Server violates a constraint during a workflow.
6. Key relationships: You can customize the Warehouse Designer to automatically create primary key-foreign key relationships.
You can also create logical relationships in the repository. Key relationships do not have to exist in the database.
Steps to import a relational target definition

In the Warehouse Designer, choose Targets-Import from Database.
Select the ODBC data source used to connect to the target database.
Enter the user name and password needed to open a connection to the database, and click Connect.
Specify the Schema Name from where you want to get the target definition.
Select the relational table or tables to import the definitions into the repository.

No comments: