In this tutorial you will load a dimension that stores geographical information.
Create a new transformation.
Drag a Table input step to the canvas and double-click it.
As connection select
js.In the SQL area type the following query:
SELECT ci.city_id, city_name, country_name FROM cities ci, countries co WHERE ci.cou_id = co.cou_id
Click on OK.
Expand the Data Warehouse category of steps.
Select the Combination lookup/update step and drag it to the canvas.
Create a hop from the Table input step to this new step.
Double-click the Combination lookup/update step.
As Connection select
dw.As Target table browse and select
lk_regionsor simply type it.
Enter
idas Technical key field andlastupdateas Date of last update field.Click OK.
After the Combination lookup/update step, add an Update step.
Double-click the Update step.
Select
dwas Connection andlk_regionsas Target table.Fill the upper grid adding the...