The Design Process
The goal
of the design process is to create mappings that depict the flow of data
between sources and targets, including changes made to the data before it
reaches the targets. However, before you can create a mapping, you must first
create or import source and target definitions. You might also want to create
reusable objects, such as reusable transformations or mapplets. For a list of
objects you create in the Design process, see Repository Objects.
1. Import source
definitions. Use the Source Analyzer to connect to the sources and import
the source definitions.
2. Create or import target
definitions. Use the Warehouse Designer to define relational, flat file,
or XML targets to receive data from sources. You can
import target definitions from a relational database or a flat file, or you can
manually create a target definition.
3. Create the target tables. If you add a target
definition to the repository that does not exist in a relational
database, you need to create target tables in your
target database. You do this by generating and executing the necessary SQL code
within the Warehouse Designer.
4. Design mappings. Once you have source
and target definitions in the repository, you can create mappings in the
Mapping Designer. A mapping is a set of source and target definitions linked by
transformation objects that define the rules for data transformation. A
transformation is an object that performs a specific function in a mapping,
such as looking up data or performing aggregation.
5. Create mapping objects. Optionally, you can
create reusable objects for use in multiple mappings. Use the Transformation
Developer to create reusable transformations. Use the Mapplet Designer to
create mapplets. A mapplet is a set of transformations that may contain sources
and transformations.
This isvery nice article keep posting
ReplyDeleteInfromatica , infromatica training, infromatica trainng in bangalore, infromatica online training