Interested to Buy Any Domain ? << Click Here >> for more details...
Give the two types of tables involved in producing a star
schema and the type of data theyhold.
- 2 Answers
- 7517 Views
- I also Faced
- E-Mail Answers
Answer Posted / monal
FACT TABLE: SALES
DIMENSION TABLE: GEOGRAPHY, PRODUCT, TIME
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
how can you find out if a table can be redefined?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
how can you connect from 10g user to 11g user??
what is ora 24313?what is the procedure to exclude that error?
How can you control the amount of free space in your index pages? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
Explain materialized views and how they are used.
what is the role of dip user in our database?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Query processing is slow(eg select query)how will u solve that
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What would you do with an "in-doubt" distributed transaction?
