OK MDXer,
But in my business i have more than 12 lookup for UIDs and more than 40 script update for massaging. I do use the second way of your suggestions but i found that the staging tables reach to more than 50 tables.
I can not imaging that the number of staging tables reach to that number...
I have dimension called Dim_Customer:
CustomerUID CustomerID CustomerName
1 1 Joe
2 2 James
3 3 Micheal
and i have Fact called SalesFact:
CustomerUID CustomerID Sales
Null 1 12
Null...
I have an integration services package that has one data flow task contains one OLEDB source, multicasting task and 3 OLEDB command tasks to update some rows in the same table but with different conditions. My question is how to make those tasks run one after one, i mean i want to make the OLEDB...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.