Loading Dimensions with Talend Open Studio
Loading...
Loading...
840
views
Loading...
23 videosTalend- 13:52
Using Talend Open Studio to synchronize data with BIRT onDemandby markymarkgamble500 views
- 9:07
Talend Open Studio. Миграция данных (1/2)by RolloutChannel416 views
- 4:30
Component Designer in Talend Open Studioby bekwam710 views
- 4:20
CSV File to MySQL Tutorial with Talend Open Studioby bekwam2,686 views
- 3:46
Design Facts, Dimensions and Transformation/Load Processes - DW Architectby DataInfoLeaders4,544 views
- 8:45
オープンソースのデータ統合ソフト Talend Open Studioby jetlee2050701 views
- 1:47
A Talend Open Studio Walkthrough: tTickRowby bekwam222 views
- 7:41
Talend Open Studio 4.2 hands-onby BusinessComputingTV293 views
- 6:28
Dimensional Fact Model: dalla teoria alla praticaby cazzella950 views
- 4:27
Tuto vidéo Talend Open Studio : Mapping avec Jointuresby labdeci350 views
- 6:30
CloverETL Excel to MySQL Tutorialby bekwam690 views
- 5:17
Talend and JasperReportsby opensourcebi2,218 views
- 7:35
Video tutorial: Talend Integration Suite demonstrationby TalendChannel1,408 views
- 1:34
A Talend Open Studio Walkthrough: Manipulating Oracle XMLType CLOBsby bekwam594 views
- 7:20
Dédoublonnage de données et démo - Sebastiao Correia, Chef de Projet Qualité de Donnéesby TalendChannel297 views
- 3:44
Versatile File Processing with Talend Open Studioby bekwam291 views
- 2:02
A Talend Open Studio Walkthrough: Producing XMLby bekwam936 views
- 5:14
Talend open studio:ETLby ssleo10120 views
- 8:19
Talend Open Studio. Миграция данных (2/2)by RolloutChannel267 views
- 11:36
Talend and Greenplum integration - Short demonstrationby TalendChannel638 views
In this MySQL target, the surrogate key is an auto_increment field. This would be the same for MS SQL Server.
Oracle and Postgres uses a sequence (mysequence.NEXTVAL) to generate the surrogate key.
In Oracle's case, it's possible to first retrieve a sequence and then apply it to more than one target. When using an auto_incr field, you'll need to retrieve the key by a query in the same transation to apply it elsewhere.
Consider using a tMysqlOutput rather than a tMysqlRow .
bekwam 2 months ago
Be sure to check out bekwam.blogspot.com/2011/02/talend-open-studio-date-dimension-job.html for the date dimension
bekwam 1 year ago