You want to create an object used several times in other Transformations. Should you create a table or a view?A.TableB.ViewC.Either of the two
Question
You want to create an object used several times in other Transformations. Should you create a table or a view?
A. Table
B. View
C. Either of the two
Solution
B. View
Here's why: A view is a virtual table based on the result-set of an SQL statement. It contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database. If you have an object that is used several times in other transformations, it would be more efficient to create a view. This is because views do not occupy physical space in your database as tables do. When you query a view, you are actually retrieving data from the underlying tables. This can be more efficient if the view is based on a complex query that is used repeatedly.
Similar Questions
You should create a table instead of a view if many transformations need to access the results.A.TrueB.False
Which of the following type of class allows only one object of it to be created?
Which of the following operation will create duplication of table?*1 pointDeleting a tableCopying a tableMoving a tableCreating a table
The following CREATE SQL statement are correct EXCEPT _____.a.CREATE TABLEb.CREATE SQLc.CREATE SCHEMAd.CREATE VIEW
elect the correct answerWhich of these method of Object class can clone an object?OptionsObject clone()copy()Objectcopy()clone()
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.