Bonjour, I'm working on a project to integrate operational data using Talend Open Studio. I wanted to know if TOS has a Data Staging Area. I'm not looking to load a DWH , I just want to know if during the "Transform" (mapping) phase where will be saved the data temporarily before loading them into database targets. It is not Data staging area in this case?
/* Je suis entrain de bosser sur un projet d'intégration de données opérationnelles avc Talend Open Studio . Je voulais savoir si TOS possède concrètement un Data Staging Area . Merci de me préciser dans quel étape se situe cet espace et s'il ya de la documentation sur cet espace dans Talend ça serait vraiment génial. */
Hi,
A Data Staging Area is usually used to store data before loading a DWH.
What you are looking for is documentation about building a DWH not about Talend.
Talend is the tool that will help you build the DWH, but you will have to start with a lot of thinks first.
Please refer to the standart DWH litterature (Kimbal...)
regards,
benjamin
Hi, Thanks for the answers. This is the question in english : I'm working on a project to integrate operational data using Talend Open Studio. I wanted to know if TOS has a Data Staging Area. I'm not looking to load a DWH , I just want to know if during the "Transform" (mapping) phase where will be saved the data temporarily before loading them into database targets. It is not Data staging area in this case? Best Regards, Aymen
Oky, I get your point. Talend does not use an "internal" staging area as it process data on the flow. But if you want to have one, you can easily scratch your data in disk on DB or file. After it depends which component your are using. Bulk component are using a file staging by default. regards, benjamin