How to load data into Dimension table
Posted: Wed Mar 07, 2007 10:39 pm
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.
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