topic Re: star schema talend in Talend Studio

star schema talend

_AnonymousUser — Sat, 16 Nov 2024 13:51:26 GMT

Salut,
j'essaie de créer un schéma étoile (dimension, table de facts) a partir d'un fichier excel avec Talend. Est ce que quelqu'un connait les composants à utiliser?
je ne le vois pas dans le user_guide.
Merci

Re: star schema talend

Anonymous — Sat, 25 Jul 2009 04:35:03 GMT

Hello
Can you post your question in English?
Best regards
shong

Re: star schema talend

_AnonymousUser — Mon, 27 Jul 2009 13:14:27 GMT

Hello,
i'm trying to build a datawarehouse with star schema (Dimension tables and fact table). My data Source is an excel file. Do you know wich componants i need to use with Talend.

Re: star schema talend

Anonymous — Mon, 27 Jul 2009 16:15:04 GMT

Hello
You can use tFileInputExcel component to extract data from excel file and load them into database with tDBOutput, like tMysqlOutput. A simple job looks like:
tFileInputExcel-->tMysqlOutput
Best regards
shong

Re: star schema talend

_AnonymousUser — Tue, 28 Jul 2009 08:43:59 GMT

Thank you shong.
i knew how to do this simple job.
my problem is:
i have an excel file as input; it contains sales information (StoreName, Category,Item,SaleAmount), i need 2 dimension tables containing StoreNames in one hand and Category&Item in the other. My fact table will contain the SaleAmount and the primary keys of the two dimension tables > that will be my star schema.
what i tried to do:
tFileInputExcel-->tMap-->tMysqlOutput (two tMysqlOutputs for my two dimension tables);
but after that i don't know how to reuse this two tables as input of an other Tmap to create my fact table in the same job.
Best regards

Re: star schema talend

Anonymous — Tue, 28 Jul 2009 10:07:01 GMT

Hello
I understand your problem, because Talend don't allow you to create a cycle flow in a job. So, you need two tMysqlInput components to query records from the two table and link them to another tMap.
tFileInputExcel-->tMap-->tMysqlOutput (two tMysqlOutputs for my two dimension tables);
|
onsubjobok
|
tMysqlInput_1--tMap--->fact table
|
tMysqlInput_2
Best regards

shong