Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / Richa Chaurasia
In Talend, SCD (Slowly Changing Dimension) can be implemented using the tUpdateUpdate and tUpdateInsert components. tUpdateUpdate is used for updating existing rows in a dimension table while preserving their history, and tUpdateInsert is used for inserting new records. By combining these components with the appropriate logic, you can handle different types of SCD scenarios such as SCD Type 1 (overwrite), SCD Type 2 (add new record and update old record), and SCD Type 3 (add new record and maintain history).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
