How do I exactly approach? I mean what transformations should I be using to do all the above mentioned steps?

Thank you

I know, I was a little nervous and it was really stupid of me to actually expect help without providing the required info about the schema and the View itself....

Thank you,

It helped.

I didn't mean to cross post, I was getting an error while posting my question, I thought it was not posted so I kep posting it, just realized that it...

Thank you,

Table a is not that big, Table b has hhhhhhuge data.. I am only allowed to play around with A, I can not do anything with the data or...