Zero To Hero - IICS || DAY-20 || SCD Types - 0,1,2,3,4,6 || In Detail Super Explanation Video....... скачать в хорошем качестве

Zero To Hero - IICS || DAY-20 || SCD Types - 0,1,2,3,4,6 || In Detail Super Explanation Video.......

IICS: SCD Types (Slowly Changing Dimensions) In Informatica Intelligent Cloud Services (IICS), the same Slowly Changing Dimension (SCD) types as in traditional data warehousing practices are applicable. IICS supports the implementation of these 6 types of SCDs, either through built-in transformations like Lookup, Expression, and Update Strategy or via custom mappings. 1. SCD Type 0 (Static Dimensions) •Description: The dimension data never changes. Once inserted, it remains static. •Use Case: Useful for data that should not be altered (e.g., historical reference data). 2. SCD Type 1 (Overwrite) •Description: Overwrites the old data with new data; no history is maintained. •Use Case: For corrections or when historical data is not required. 3. SCD Type 2 (Historical Tracking) •Description: Maintains a complete history of changes by inserting new rows for updates and tracking with dates or flags. •Variants: o Row Versioning: Tracks rows with a version number. o Effective Dates: Uses start and end dates to define the validity period. o Current Flag: Uses a flag to identify the current record. 4. SCD Type 3 (Limited History Tracking) •Description: Maintains limited history by adding extra columns to store previous values. •Use Case: When only the immediate past and present values are required. 5. SCD Type 4 (Historical Table) •Description: Uses a separate historical table to store all changes, while the main dimension table holds only the current record. •Use Case: For separating historical data from the current dimension to improve query performance. 6. SCD Type 6 (Hybrid SCD or Type 1 + 2 + 3) •Description: Combines Type 1, Type 2, and Type 3 techniques to meet complex business needs. •Use Case: When different attributes in a dimension require different methods of handling changes. Summary: Type 0: Insert only – Static Data Type 1: No history will be maintained Type 2: History will be maintained at Row level Method 1 - Flag Method 2 - Version Method 3 - Date Type 3: Recent history will be maintained at column level Here is the link for the SCD Types Document: https://drive.google.com/file/d/128VV... Excel File Link: https://docs.google.com/spreadsheets/... Please do subscribe to my channel for more videos and hit the bell icon for daily updates. Below are the things will cover in the IICS Live training: 1. Professionally holding 10+ years of IT Experience in different domains 2. Interview preparation from Day - 1 2. Low-cost training with real time scenarios 3. Job Assistance once training completes 4. Resume preparation & mock interviews 5. 100% job-oriented training Join using below link to Informatica/IICS community group: https://chat.whatsapp.com/GhtzLq1kZrK... Please reach out to me for Informatica Training for Beginners or experienced or who are looking to jump into IT Sector. What's app/ping me: 6360407797 Email: informaticaIICS2024@gmail.com Regards, Adike's InfoTech