I need to create a ETL project to import the data to the DW. There are amny tables, of course. Soome of them are lookup table and ususally do not change. Some are changed everyday, such as the price table.
What I'd like to know is the best practice to design packages. For example, shall I create a Mast package that calls the othere packages, and "other" package(s) perform a single set of task? Shall I deisgn one package per table?
I really need some wise advice.