Type 6 SCD transformation are very very specific.

Seldom the need arises to maintain a history table.

Puja...you know my comment was on a lighter note...we allare here to help each other....

I would suggest that you familiarize yourself with...

What is fact, fact table, dimension, dimension table and most important what goes into fact/dimension table.

Once you set the right momentum...you'll find your learning curve smooth enough to model the same into advanced analytics.