surrogate key: interger value randomly assigned to know rows in a table.

olap : here data is stored for analysis or some comparison for the development of business or to know where they stand. here there may be many historical data since its main objective wud b to compare data for deriving some bi.

oltp:these are transaction data for periodiacally running business. these datas are updated everytime and they dont store historical data.