Give the two types of tables involved in producing a star
schema and the type of data they hold.
Answer / rajeev kumar singh
Fact tables and dimension tables. A fact table contains measurements while dimension tables will
contain data that will help describe the fact tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
please send me oracle pl/sql exp resume. and also faqs...
write a query to find the third maximum salary of a employee.(table:employ col name:salary)
What is the disk migration? what is the steps involved in oracle disk migration?
When a user process fails, what background process cleans up after it?
how to replace not in with not exist?
What is auto invoicing? : oracle accounts receivable
Difference between transaction type and transaction sources. : oracle accounts receivable
What view would you use to look at the size of a data file?
Explain the difference between a data block, an extent and a segment.
How would you go about generating an EXPLAIN plan?
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable