(De)normalization with ETL

CloverDX Platform
1

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.

2

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

3

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