Question { TCS, 50388 }

What is Data purging?

Answer

Information sources may be unreliable and may purge data. On
the other hand, information at the warehouse is under the
control of the warehouse users; it can be stored safely and
reliably for as long as necessary.

Question { 4781 }

If you have 10 mappings designed and you need to implement
some chages (may be in existing mapping or new mapping need
to be designed) then how much time it takes from easier to
complex?

Answer

It depends on the complexity of resuablity or re-mapping
based on the client specification.

So this question is to check whether r u smarter enough to
understand the existing mapping and design new ones.

Question { TCS, 18038 }

what is the logic will you implement to load data into a
fact table from n dimension tables?

Answer

fact table should contain all foreign key (PK) of the
dimensional tables, and it should be measured based on the
measures in the fact table as per the client specification.