[resolved] How to work on Accumulating Snapshot Fact table in TIS
My Fact table rely on a SCD Type 2 Dimension table. And my Fact table is in accumulating snapshot model.
Please let me know how to update the fact table in this situation. (Update existing row and insert a new row) - similar to SCD Type 2.
Is there a component for that?
I am using Jaspersoft ETL 5.4.1 Ent version
Source: Oracle database Target: Red shift database
1.My task is in my source database having 600 tables(all tables have different matadata).
2. All 600 tables shift into redshift database in between shift i can apply SCD Type 2 for all tables.
3. Client want to create one SCD type2 template and use for all 600 tables no need to create SCD Tyep2 for 600(by using row hash) it's having data columns.
Hi,
Could you please confirm if we can create a generic job in talend which performs different operations on different sets of data.
Basically, we want to process multiple source files (having different schema) with different transformations but the overall processing flow in the job is same for all source files. (Eg a simple Job Flow : FileInputDelimited -> TMap -> tFileOutputDelimited).
If we can create such a generic job, then please help on below points :
1) How to save and pass different schema definition for different source files via parameter/file
2) How to pass key field via parameter/file
3) How to save and pass different transformations via parameter/file
