Hi KB,

If you got the solution, could you please share with me.

Because I am is also in same situation. But I don't have option and I should use triggers.

can any...

Thank you for your valuble inputs.

Lets forget about wether it is Fact or Dimension. My question is how to handle lookup transfermation to cache 2 billion records. Do I need...