Yes i am able to as you guided thanks to both for help and guidance. special thanks to Thom for understanding the requirement and help me thank you both.

yes i want to add a derived column to it to assign a unique identifier

I had done this how ever i have to achieve this using SSIS and add a Derived column for it? is there a way to pass my tablename to variable...

Thank you and appreciate your efforts in understanding the problem and helping me in solving it.

Is the table of table names simply just that (a table, with one column, containing table names)? Yes  it is.

Are the surrogate tables and the master table exactly the...

Yes what you are saying is right.
I have table which has tables names in its column. What i have to do is use that names for the column then...