fact table and dimension table containg one to many
relationship or many to one relastionship
No Answer is Posted For this Question
Be the First to Post Answer
Explain the family trees and connection by clause.
How to generate OIDS
explain detail about ftp in datastage?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What is the system function to get the current user's user id?
Define candidate key, alternate key, composite key?
30 Answers IAS, IBM,
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
how to find the first two highest salaries in deptno in emp table
Who are naive users?
What are the constraints on severity level in raiseerror?
Explain about xml databases?
Write short notes on manual refreshes.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)