https://community.qlik.com/t5/Talend-Studio/How-to-create-a-star-schema-with-Talend/m-p/2309817#M81002 Hello Everybody! <BR />I have a excel file witch I do the Extract, the transformation and the loading in dababase MySQL 5.0.Everythins is ok but the next step for me It's to create a data model : schema star, the problem it's I don't know how to start , I tried te seached in the internet but I didn't found any thing for help!! <BR />Please help me! <BR />thanks <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA9p.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138034i5F552429DA646D6F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA9p.png" alt="0683p000009MA9p.png" /></span> Sat, 16 Nov 2024 13:47:58 GMT Anonymous 2024-11-16T13:47:58Z https://community.qlik.com/t5/Talend-Studio/How-to-create-a-star-schema-with-Talend/m-p/2309817#M81002 Hello Everybody! <BR />I have a excel file witch I do the Extract, the transformation and the loading in dababase MySQL 5.0.Everythins is ok but the next step for me It's to create a data model : schema star, the problem it's I don't know how to start , I tried te seached in the internet but I didn't found any thing for help!! <BR />Please help me! <BR />thanks <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA9p.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138034i5F552429DA646D6F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA9p.png" alt="0683p000009MA9p.png" /></span> Sat, 16 Nov 2024 13:47:58 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-a-star-schema-with-Talend/m-p/2309817#M81002 Anonymous 2024-11-16T13:47:58Z https://community.qlik.com/t5/Talend-Studio/How-to-create-a-star-schema-with-Talend/m-p/2309818#M81003 This is what I think, for having worked with this kind of schemas in business intelligence projects. <BR />A schema star is just a data model, you say it right. It will describe the content of the different classes and the relationships between them. You can draw this schema on a sheet of paper in UML language. <BR />Then you'll have to implement this schema, which means setting up the database structure. One table for every UML class and foreign keys for the links. Refer to SQL documentation. <BR />Talend will be your best friend when comes the time to fill the database. To work with it on Talend, just consider a bunch of separate tables. The only problems you will encounter are foreign key dependancies, and you will have to fill the tables in an appropriate order. <BR />Have fun Thu, 27 Aug 2009 17:11:24 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-a-star-schema-with-Talend/m-p/2309818#M81003 Anonymous 2009-08-27T17:11:24Z