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.
Write down the differentiation between lookup and filter transformation?
What is significance of “ * ” ?
Write down the snapshot with reference to data warehouse?
Specify the several types of Strategies?
Briefly describe the capabilities and concepts of Business Intelligence?
What are the catches?
Specify the designer tools used for creating the tranformations?
Explain and compare OBE and SQL?
State the components of report studio?
Describe briefly the different methods of loading Dimension tables?
18,76,764
1958305 Asked
3,689
Active Tutors
1411893
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!