Hi All,
Thank you for the responses.
cihangirb - The purpose we are looking for temp tables is, we get data from multiple sources and we embed this data into sing table(if we consider SQL here) that gets used for further processes.
For example, We get user information from 3 source table like UserDetails, UserEmailIds and UserTelephoneNumbers. Using these 3 tables we generate final table User which has all the information. So these 3 tables becomes our temp tables which we delete after generating final User table.
Thanks,
Sameer