(De)normalization with ETL

jfaerman

• October 28, 2008 00:00

• Answered

Follow

Hello,

I am new to ETL in general, and just found out Clover. I would like to know if it would resolve the following situation.
Say i am migrating from database schema A to B.

In schema A, i have a single Employee table, such as:

Employee - City
Jhon - New York
Paul - New York
Mary - Chicago

In schema B, i have two tables

Employee - CityID
Jhon - 1
Paul - 1
Mary - 2

CityID - CityName
1 - New York
2 - Chicago

Is it possible to automate such transfer with Clover?
I have several variations of similar problems. Is there documentation on this?

Thank you very much, sorry for the newbie question.

• 

  avackova

  • October 30, 2008 08:35

  0

  Comment actions Permalink

  Hello,
  full documentation you can found on http://www.cloveretl.org/documentation/ and on CloverETL Wiki.
  Example solution of your task:
  1. DBInputTable: read data from employee table
  2. SimpleCopy - multiply data to 2 streams
  3. Dedup - deduplicate cities
  4. DBOutputTable - insert data to city table, get autogenerated keys
  5. HashJoin - join employees with cities
  6. DBOutputTable - insert data to employee table
• 

  jfaerman

  • October 30, 2008 12:02

  0

  Comment actions Permalink

  I'll chek it out, thank you very much.

Please sign in to leave a comment.