i am very new to teradata, please help me with your valuable suggestions
i want to know in which case we have to choose a (volatile table,global temp table,derived table)
please help me
These all tables that you mentioned keep the data temporarily with different purpose. If you are looking to store the data permanently then you should not use either of these kind. Let us know what is your purpose and will guide what would be the best for you.