Search:

yes, it is possible using tool. plz once go through the options available

sorry it is not possible in my view
since you can point one mapping in more than one session but not vice versa

Fact table is surely normalized. (I can't justify please)

For surrogate key, dimension is parent table and fact is the child table. i.e. in dimension table only, sk resides.

With the use of sk...