Give the two types of tables involved in producing a star
schema and the type of data theyhold.
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
what do you understand by flashback feature of oracle?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
what are the differences of where and if in SAS?
how can a session indicate its interest in receiving alerts?
What the different components in replication and what is their use? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
what are the benefits of flashback feature?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Where would you look for errors from the database engine?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what is the role of dip user in our database?