How to load data into Dimension table

[swathi.mekala]

Hi all,

How to load data into Dimension table.
The following is my requirement
We have Dimension table as Gl_Acct_Dimnsn ,it contains columns like Gl_Acct_Id,Gl_Acct_Nbr,Gl_Acct_Grp etc.
We have to load the Gl_Acct_Nbr from source table (which contains column Gl_Acct_Nbr) to Gl_Acct_Dimnsn table.
I have to lookup on same Gl_Acct_Dimnsn table to ignore duplicate values.
The lookup table and target table(Dimension table) are same.

Thanks
Swathi

[sushanth]

Hi all,

How to load data into Dimension table.
The following is my requirement
We have Dimension table as Gl_Acct_Dimnsn ,it contains columns like Gl_Acct_Id,Gl_Acct_Nbr,Gl_Acct_Grp etc.
We have to load the Gl_Acct_Nbr from source table (which contains column Gl_Acct_Nbr) to Gl_Acct_Dimnsn table.
I have to lookup on same Gl_Acct_Dimnsn table to ignore duplicate values.
The lookup table and target table(Dimension table) are same.

Thanks
Swathi

Hi,

If the target DIM table is with data prior to load,then you take
reference look up with this table in one job, once all the non duplicate records collected then load the Target DIM table in a second job.

Regards

[kumar_s]

Use CDC.
COPY code can be ignored. Rest of the codes can have their corresponding DML statement.

[ray.wurlod]

You can use any of the Change Capture, Compare or Difference stages to compare your new data with the existing dimension table. You don't need to build a lookup table.