0

i have 50 customer and i am asked to design a SSIS package to handle the Slow Changing Dimension.

i have designed the entire package for it.

The real challenge for me.

How can i make sure if any new customer file arrived for the first time, it will load to the table Warehouse and not in the staging table.

that means latest file from customer should be always load into staging table and oldest file which arrived for the first time will be in warehouse table.

May be it looks broad question, but i am badly need of expert advise.

I am pretty new to SSIS , May anyone please share your expertise.

Thanks

Rohini Mathur
  • 431
  • 1
  • 5
  • 19
  • Different customer have unique customerid...... – Rohini Mathur Jun 23 '16 at 11:08
  • Normally _every_ file arrives in staging. Then any differences between staging and the dimension are applied to the dimension. When the next file arrives, the staging table is truncated and the process repeats. I don't understand your question. – Nick.Mc Aug 22 '16 at 05:48

0 Answers0