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
How to load data into Dimension table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Mon Dec 04, 2006 10:30 pm
- Contact:
Re: How to load data into Dimension table
Hi,swathi.mekala wrote: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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.