I am new to teradata database and its different utilities. We are building a datawarehouse where we are processing raw data to warehouse hables using some ETL tool. Now we need to create data marts over warehouse transaction tables to summarize data.
The summary tables will be containing data from 2-3 fact tables. Please let us know the best approcah for populating summary tables. Should we write some stored procedure or there is any utility tool by teradata for the same.