Before we create a mapping, we must define targets in the repository. Use the Target Designer to import and design target definitions. Target definitions include properties such as column names and data types.
Types of target definitions:
- Relational: Create a relational target for a particular database platform.
- Flat file: Create fixed-width and delimited flat file target definitions.
- XML file: Create an XML target definition to output data to an XML file.
Ways of creating target definitions:
1. Import the definition for an existing target: Import the target definition from a relational target or a flat file. The Target Designer uses a Flat File Wizard to import flat files.
2. Create a target definition based on a source definition: Drag a source definition into the Target Designer to make a target definition and edit it to make necessary changes..
3. Create a target definition based on a transformation or mapplet: Drag a transformation into the Target Designer to make a target definition.
4. Manually create a target definition: Create a target definition in the Target Designer.
5. Design several related targets: Create several related target definitions at the same time. You can create the overall relationship, called a schema, and the target definitions, through wizards in the Designer.
After we create a relational target table definition, we need to create a table in Database also.
Steps:
- In the Target Designer, select the relational target definition you want to Create in the database. If you want to create multiple tables, select all relevant table definitions.
- Click Targets > Generate/Execute SQL.
- Click Connect and select the database where the target table should be Created.
- Click OK to make the connection.
- Click Generate SQL File if you want to create the SQL script, or Generate and Execute if you want to create the file, and then immediately run it.
- Click Close.
No comments:
Post a Comment