Based on the requirement to your fact table, choose the sources anddat a and transform it based on
your business needs. For the fact table, you need a primary key so use a sequence generator
transformation to generate a unique key and pipe it to the target (fact) table with the foreign keys
from the source tables.
No comments:
Post a Comment