Messages

1

Uml Process / Re: How to Model ETL (Extract Transform Load) mapp

« on: September 11, 2008, 01:07:18 am »

Hi ,

Create association classes between the source and target and name this class source_target_transform. Identify the input_attributes and output_attributes. The methods or operations are the transformation code.

Segun

Good idea. How do I identify the input and output attrubutes? I tried in the Details/Attributes form but I need to retype all the attributes. I cannot link them.

What I am trying to do is to is
1. Link Source Table colums --> transformation process --> Target Table columns.
2. document the transformation rules in the transformation process
3. With the table columns linked (not typed in) I get an impact analysis tool that helps me assess the impact when a source column changes.

2

Uml Process / How to Model ETL (Extract Transform Load) mapping

« on: September 09, 2008, 05:31:18 am »

Hello all

I am asked to create a UML model that has the following:

1. Staging Tables & attributes
2. ODS Tables & attributes & relationships
3. Data Mart Tables & attributes & relationships
4. Data mapping and transformation rules between Staging tables/attributes to ODS tables/attributes.
5. Data mapping and transformation rules between ODS tables/attributes to Data Mart tables/attributes.

I have created 1 to 3 using the Data Modeling provided by EA. I am not sure how to model items 4 and 5.

Your input or ideas would be appreciated, Thanks