Here there are the differences:
In a general way ODS is the DB that contains data from the OLTP systems but that data is used to support the tactical decision making process.
DW(Data Warehouse) is the summary of ODS data that is used to support eh strategic decision making...
Hi
If you are lookign for information about etl tools that deal with mainframe just take a look at www.datawarehouse.com and there is a list of different partners that offer the etl tools.
Or if I cna recomend you a good tool could be Datastage from ardent or Power Mart from Informatica...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.