how does composite key work in loading SCD dimension ?
Hi.
I have the following DB configuration in Source:-
id number (PK)
id_version number (PK)
name varchar2(255)
and following DB configuration in TRGT:-
row_id number (SK)
d_id number (NK)
d_name varchar2(255)
Following are the ODI Mappings for TRGT:-
row_id number (SK) (ins, trgt)
d_id number (NK) (ins, trgt)
d_name varchar2(255) (ins/upd, trgt)
How do I take care in loading this type2 SCD load? It gives me error in creating unique index. As partial key i.e. id_version is not taken care of.
How do i define composite keys in this case?