Solving the problem of deleting the table
State the steps for “this message could not delete” from the particular tables?
Expert
This error is caused due to the delete query and when unique property is set to “no”.
Following given are the steps that must be followed in order to solve the problem.
1) Delete query must be opened and if it is not opening then press F4.
2) Clicking on the query properties underneath query designer will provide you the options.
3) In that options, you require to locate the unique records property and must set it to yes. These options are present in the query property sheet.
Is the shortest distance between any 2 specified nodes is given by minimum spanning tree?
What are to objectives of OLE DB?
Explain the Equilibrium Price in brief.
Specify some of the areas where the data warehouses are utilized in the present and in the future?
Explain the operations that can be done with the Data Stage Director?
Illustrates the applications of ASA?
Another company used statistic in reports is the total number of orders placed by a shopper. Complete the following steps to create a function named NUM_PURCH_SF that accepts a shopper id and returns the total number of orders the shopper has placed. Use the function in a SELECT statement to display
Describe briefly the different methods of loading Dimension tables?
Describe briefly the difference between pessimistic locking and optimistic locking?
Explain the Aggregator Transformation?
18,76,764
1925976 Asked
3,689
Active Tutors
1440479
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!