June 16, 2008 at 10:19 am
Hi friends,
Can somebody please help me with the following questions.
1.If there is no look up table but only have Fact-table, how can we add dimensions to it?
2. How can we implement database in physical level?
Thankssss a lot
June 16, 2008 at 11:40 pm
Uhmmmm
I am not understanding nicely. Do you mean there is no dimension currently, or do you mean that there is a dimension, but simply no SSIS lookup table?
You can use a dimension to look up key values (making it a lookup table).
Alternatively, research on early arriving facts and their usage in SSIS. Crux of the matter is that you can insert into the dimension from the fact, prior to looking up values (almost like when you are working with lookups and redirecting the error stream to insert into the dimension, and re-looking up the key values). My only suggestion that I can give you is to work out nicely what your business rules are (for example, we have a sales fact, and it sure as oats is a problem if the employee record is not found on the employee dimension - points to some business process not being followed in payroll).
Please be a little more specific as to what you want to achieve.
As to creating the physical schema, are you working with a tool such as Sybase Powerdesigner or Erwin? These have the ability to create the physical model at RDBMS level. Either way, your database will have to be created before you start your ETL design. The key requirement of SSIS is that it will require an OLEDB connection to your physical structure in this case. However, note that you can create the tables from your SSIS palette.
Good luck
~PD
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply