filmov
tv
12.2 Mapping to implement SCD Type1 using SQL and IICS #iics
Показать описание
Mapping to implement SCD Type1 using SQL and IICS
SQL:
select
Tgt_SK
,EMPNO
,ENAME
,JOB
,MGR
,HIREDATE
,SAL
,COMM
,DEPTNO
,Created_date
,Updated_date
,Delete_Flag
,stg_hash_key
,tgt_hash_key
,case
when Tgt_SK is null then 'I'
when Tgt_SK is not null and stg_hash_key!=tgt_hash_key then 'U'
end as Ins_Upd_Flag
from
(
select
tgt.SK as Tgt_SK
,stg.EMPNO
,stg.ENAME
,stg.JOB
,stg.MGR
,stg.HIREDATE
,stg.SAL
,stg.COMM
,stg.DEPTNO
,sysdate as Created_date
,sysdate as Updated_date
,'N' as Delete_Flag
,stg.EMPNO||stg.ENAME||stg.JOB||stg.MGR||stg.HIREDATE||stg.SAL||stg.COMM||stg.DEPTNO as stg_hash_key
,tgt.EMPNO||tgt.ENAME||tgt.JOB||tgt.MGR||tgt.HIREDATE||tgt.SAL||tgt.COMM||tgt.DEPTNO as tgt_hash_key
from stg_emp stg
left join tgt_emp_scd tgt
) a
SQL:
select
Tgt_SK
,EMPNO
,ENAME
,JOB
,MGR
,HIREDATE
,SAL
,COMM
,DEPTNO
,Created_date
,Updated_date
,Delete_Flag
,stg_hash_key
,tgt_hash_key
,case
when Tgt_SK is null then 'I'
when Tgt_SK is not null and stg_hash_key!=tgt_hash_key then 'U'
end as Ins_Upd_Flag
from
(
select
tgt.SK as Tgt_SK
,stg.EMPNO
,stg.ENAME
,stg.JOB
,stg.MGR
,stg.HIREDATE
,stg.SAL
,stg.COMM
,stg.DEPTNO
,sysdate as Created_date
,sysdate as Updated_date
,'N' as Delete_Flag
,stg.EMPNO||stg.ENAME||stg.JOB||stg.MGR||stg.HIREDATE||stg.SAL||stg.COMM||stg.DEPTNO as stg_hash_key
,tgt.EMPNO||tgt.ENAME||tgt.JOB||tgt.MGR||tgt.HIREDATE||tgt.SAL||tgt.COMM||tgt.DEPTNO as tgt_hash_key
from stg_emp stg
left join tgt_emp_scd tgt
) a
0:03:42
ODI SCD TYPE 2 MAPPING
0:14:02
ODI SCD Type 2 Implementation step by step process (Slowly Changing Dimension)
0:33:31
Informatica Slowly Changing Dimensions --SCD1
0:07:33
Implementing SCD Type-2 in oracle data integrator v1
0:05:10
12 Slowly Changing Dimension Type 2 (SCD 2)
0:10:03
6 SCD Type 02 Implementation in ODI
0:12:03
11. Slowly Changing Dimension(SCD) Type 1 Using Mapping Data Flow in Azure Data Factory
0:04:14
ODI SCD TYPE 1 MAPPING
0:01:00
SCD Type 2 #sql #dataengineers #azure #adf
0:18:14
How to load SCD Type 1 dimensions? | Dataflows in Azure | Synapse Analytics | Dp203 Ep12 Part II Lab
0:09:53
Senario 7 - How to implement SCD Type-1 in Informatica
0:05:32
Implement SCD Type 2 (Slowly Changing Dimensions)
0:05:46
Data Warehouse #12: Dimensions Types - SCD - Type 2
0:24:22
IICS | Slowly Changing Dimension 2 / Version flag
0:58:42
SCD TYPE 2
0:25:30
IICS SCD Type 1 with MD5 function | IICS Tutorial SCD Types | IICS Tutorial
0:23:27
How to Implement Slowly Changing Dimension(SCD) Type 2 Using Insert and Update Commands in Snowflake
0:06:06
SCD Type 2 - Slowly Changing Dimension - Simple Use Case Part 2 - Section 3 - 1
0:21:00
IICS:SCD Type2 using MD5 Hashing
0:20:03
61. Databricks | Pyspark | Delta Lake : Slowly Changing Dimension (SCD Type2)
0:21:02
SCD Type 2 - Slowly Changing Dimension - Simple Use Case Part 1 - Section 2 - 1
0:00:59
SCD Type 1 ( Slowly Changing Dimension ) #sql #sqlserver #dataengineers #azure #scdtype1
1:00:50
Tech Chat | Slowly Changing Dimensions (SCD) Type 2
0:35:18
Slowly Changing Dimensions (SCD) Overview and Type 2 Management Tutorial
Комментарии