Hey,can anyone clear meafter data extracted from hetrogeneous sourcesit is transformed in staging area and then loadedinto datawarehouse.now what is the overall process done in datawarehouse and data from datawarehouse isis used by olap.
How to calculate the power of decimal number?There is a function power(numeric,power) but when I use {select power(2.5,3)} truncate error occures but it works on power(2,3)
How can we use Crystal Reports or Business Object to simplying the column names that are displayed in CR. We use an ODBC driver to connect to a propiteary database and it works find but all the column names are in techo-speak !
Tell the step by step procedure of taking backup of database & restore the same in case of database crash.
Latest Answer : Well there are several methods used to backup and recover the database. So it depends on scenario which methods has to be followed.Go through the link given below to learn more about Backup & Restore:-http://download.oracle.com/docs/cd/B10501_01/server.920/a96519/toc.htm ...
How can we perform block level recovery in database files?
Latest Answer : In Oracle this is how you do:-Syntax:-SQL>block recover datafile datafilenumber block blocknumber;Ex:-SQL>block recover datafile 2 block 1234; ...