Data Warehousing

Data Warehousing
by

1 Answer

Answer :

Data warehousing is storing data effectively so that it can be accessed and used efficiently. Different  organizations collect different types of data, but many organizations use their data the same way, in  order to create reports and analyze their data to make quality business decisions. Data warehousing is  usually an organizational wide repository of data, however for very large corporations in can encompass  just one office or one department.
by

Related questions

The major functions of SHS Wholesale include all of the following EXCEPT A)selling to the final consumer. B)warehousing, shipping, and product handling. C)financing and budgeting. D)marketing research and information systems. E)inventory control and data processing.

Description : The major functions of SHS Wholesale include all of the following EXCEPT A)selling to the final consumer. B)warehousing, shipping, and product handling. C)financing and budgeting. D)marketing research and information systems. E)inventory control and data processing.

Last Answer : A)selling to the final consumer.

Repository of information gathered from multiple sources, storing under unified scheme at a single site is called as (A) Data mining (B) Meta data (C) Data warehousing (D) Database

Description : Repository of information gathered from multiple sources, storing under unified scheme at a single site is called as (A) Data mining (B) Meta data (C) Data warehousing (D) Database

Last Answer : (C) Data warehousing

Consider the following two statements: (a) Business intelligence and Data warehousing is used for forecasting and Data mining. (b) Business intelligence and Data warehousing is used for analysis of large volumes of sales data. Which one of the following options is correct? (A) (a) is true, (b) is false (B) Both (a) and (b) are true (C) (a) is false, (b) is true (D) Both (a) and (b) are false

Description : Consider the following two statements: (a) Business intelligence and Data warehousing is used for forecasting and Data mining. (b) Business intelligence and Data warehousing is used for analysis of large volumes of sales data. Which one ... C) (a) is false, (b) is true (D) Both (a) and (b) are false

Last Answer : (B) Both (a) and (b) are true

What kind of utility does warehousing create ?

Description : What kind of utility does warehousing create ?

Last Answer : Warehousing creates temporal utility.

Planvisage is Software company or warehousing?

Description : Planvisage is Software company or warehousing?

Last Answer : I have done a research about the company this what I have got and base on my understanding. Planvisage is a software solution company specializing ins Supply Chain Management solutions and ... are not manufacturer or software company, but they are distributors which is belong to warehousing.

How to Improve Inventory Accuracy In Warehousing?

Description : How to Improve Inventory Accuracy In Warehousing?

Last Answer : Warehousing is, perhaps, the most important aspect of any business. Every business deals with a warehouse in one form or another. Inventory accuracy is critical for planning and for shipping. The key ... with the shipping department. It is not until an ordered is pulled that errors in inventory a

The Warehousing Corporations Act came into operation on

Description : The Warehousing Corporations Act came into operation on

Last Answer : Ans. 18 th March, 1962

Buffer stock operations are conducted by - (1) Warehousing Corporation of India (2) State Trading Corporation of India (3) Food Corporation of India (4) Ministry of Agriculture

Description : Buffer stock operations are conducted by - (1) Warehousing Corporation of India (2) State Trading Corporation of India (3) Food Corporation of India (4) Ministry of Agriculture

Last Answer : (3) Food Corporation of India

Which is a function of E-commerce a) Marketing b) Advertising c) Warehousing d) All of the above

Description : Which is a function of E-commerce a) Marketing b) Advertising c) Warehousing d) All of the above

Last Answer : d) All of the above

Which is not a function of E-commerce a. marketingb. advertising c. warehousing d. none of the above

Description : Which is not a function of E-commerce a. marketingb. advertising c. warehousing d. none of the above

Last Answer : c. warehousing

Which is a function of ERP? a. Warehousing b. Sales c Scheduling d. all of the above

Description : Which is a function of ERP? a. Warehousing b. Sales c Scheduling d. all of the above

Last Answer : b. Sales

Mark the correct option: a) Rate applicable for recall of foreign article in case letter 10gm & Telegraph 15 words b) The fee paid for the recall will not be refunded under any circumstances c) Weight more than 500gm a warehousing charge at the rate per day commencing from eight day, shall be collected from the addressee at the time of delivery. d) All the above are correct

Description : Mark the correct option: a) Rate applicable for recall of foreign article in case letter 10gm & Telegraph 15 words b) The fee paid for the recall will not be refunded under any circumstances c) Weight ... , shall be collected from the addressee at the time of delivery. d) All the above are correct

Last Answer : d) All the above are correct

Of the following functions, which set is MOST likely to be passed on to wholesalers by producers ? 1. Transportation, Packaging and Financing 2. Product Development, Advertising and Financing 3. Warehousing, Transportation, and advertising 4. Financing, Transportation and Branding 5. Market Information, Transportation, Warehousing and Financing

Description : Of the following functions, which set is MOST likely to be passed on to wholesalers by producers ? 1. Transportation, Packaging and Financing 2. Product Development, Advertising and ... 4. Financing, Transportation and Branding 5. Market Information, Transportation, Warehousing and Financing

Last Answer : Market Information, Transportation, Warehousing and Financing

A channel of distribution is a group of individuals and organizations that 1. directs the flow of products from producers to customers 2. links producers to other marketing intermediaries 3. takes title to products and resells them 4. manages transportation and warehousing functions 5. none of these

Description : A channel of distribution is a group of individuals and organizations that 1. directs the flow of products from producers to customers 2. links producers to other marketing intermediaries 3. ... to products and resells them 4. manages transportation and warehousing functions 5. none of these

Last Answer : directs the flow of products from producers to customers

Which is correct order of cold chain A. Farming, production, packing sales, warehousing, shopping mall, consumer. B. Farming, packing sales, consumer, shopping mall, production, warehouses. C. Farming, warehousing, shopping mall, consumer, production, packing sales. D. All of the above.

Description : Which is correct order of cold chain A. Farming, production, packing sales, warehousing, shopping mall, consumer. B. Farming, packing sales, consumer, shopping mall, production, warehouses. C. Farming, warehousing, shopping mall, consumer, production, packing sales. D. All of the above.

Last Answer : Farming, production, packing sales, warehousing, shopping mall, consumer. 

Maximum warehousing period for goods belonging to 100% Export Oriented Unit is _____. A 5 years B 3 years C 1 year D no limit on time period

Description : Maximum warehousing period for goods belonging to 100% Export Oriented Unit is _____. A 5 years B 3 years C 1 year D no limit on time period

Last Answer : Ans :no limit on time period

A bond that is executed for warehousing of goods imported in multiple imports is referred to as _____ bond. A Special B General C Higher D Lower

Description : A bond that is executed for warehousing of goods imported in multiple imports is referred to as _____ bond. A Special B General C Higher D Lower

Last Answer : Ans :Higher

Warehousing bond shall be _____ times of duty assessed on the date of warehousing. A 2 B 3 C 1 D 4

Description : Warehousing bond shall be _____ times of duty assessed on the date of warehousing. A 2 B 3 C 1 D 4

Last Answer : 3

What is the full form of SWOT ? A. Strengths, Weaknesses, Opportunities and Threats B. Software Warehousing of Threats C. single optimism technique D. none of these

Description : What is the full form of SWOT ? A. Strengths, Weaknesses, Opportunities and Threats B. Software Warehousing of Threats C. single optimism technique D. none of these

Last Answer : A. Strengths, Weaknesses, Opportunities and Threats

Which of the following is not an area of responsibility for a logistics manager? A. Inventory B. Marketing C. Information systems D. Warehousing

Description : Which of the following is not an area of responsibility for a logistics manager? A. Inventory B. Marketing C. Information systems D. Warehousing

Last Answer : B. Marketing

__________ adds time and place utility to a product by moving it from where it is made to where it is purchased and used. A)Warehousing B)Containerisation C)Distribution D)Materials handling E)Transportation

Description : __________ adds time and place utility to a product by moving it from where it is made to where it is purchased and used. A)Warehousing B)Containerisation C)Distribution D)Materials handling E)Transportation

Last Answer : E)Transportation

Greg is a physical distribution manager. He is currently developing and maintaining assortments of products that are adequate for customer demand. In which stage in the physical distribution system is Greg currently involved? A)Order processing B)Materials handling C)Inventory management D)Transportation E)Warehousing

Description : Greg is a physical distribution manager. He is currently developing and maintaining assortments of products that are adequate for customer demand. In which stage in the physical distribution ... involved? A)Order processing B)Materials handling C)Inventory management D)Transportation E)Warehousing

Last Answer : C)Inventory management

Which of the following physical distribution functions involves the design and operation of facilities for storing and moving goods? A)Order processing B)Materials handling C)Transportation D)Warehousing E)Inventory management

Description : Which of the following physical distribution functions involves the design and operation of facilities for storing and moving goods? A)Order processing B)Materials handling C)Transportation D)Warehousing E)Inventory management

Last Answer : D)Warehousing

The order -processing task that involves verifying product availability, checking prices and customer credit ratings, and filling orders is A)warehousing. B)order handling. C)information processing. D)materials handling.

Description : ThThe order -processing task that involves verifying product availability, checking prices and customer credit ratings, and filling orders is A)warehousing. B)order handling. C)information processing. D)materials handling.

Last Answer : B)order handling

When a company leases a warehouse to serve a region of the market that is not large enough and stable enough to make a long -term commitment to fixed warehousing facilities, it is employing a: A)flexible warehouse. B)dispatching centre. C)distribution centre. D)private warehouse. E)public warehouse.

Description : When a company leases a warehouse to serve a region of the market that is not large enough and stable enough to make a long -term commitment to fixed warehousing facilities, it is ... A)flexible warehouse. B)dispatching centre. C)distribution centre. D)private warehouse. E)public warehouse.

Last Answer : D)private warehouse

Order processing, inventory management, materials handling, warehousing, and transportation are __________ activities. A)wholesaling B)retailing C)physical distribution D)channel management

Description : Order processing, inventory management, materials handling, warehousing, and transportation are __________ activities. A)wholesaling B)retailing C)physical distribution D)channel management

Last Answer : C)physical distribution

Of the following functions, which set is MOST likely to be passed on to wholesalers by producers? A)Transportation, packaging, and financing B)Product development, advertising, and financing C)Warehousing, transportation, and advertising D)Financing, transportation, and branding E)Market information, transportation, warehousing, and financing

Description : Of the following functions, which set is MOST likely to be passed on to wholesalers by producers? A)Transportation, packaging, and financing B)Product development, advertising, and ... D)Financing, transportation, and branding E)Market information, transportation, warehousing, and financing

Last Answer : E)Market information, transportation, warehousing, and financing

Rapid Parcel Service is a transportation company that producers use to forward freight to customers. This example illustrates wholesaling functions performed by: A)sales offices B)sales branches C)public warehouses D)facilitating agencies E)warehousing agencies

Description : Rapid Parcel Service is a transportation company that producers use to forward freight to customers. This example illustrates wholesaling functions performed by: A)sales offices B)sales branches C)public warehouses D)facilitating agencies E)warehousing agencies

Last Answer : D)facilitating agencies

A channel of distribution is a group of individuals and organisations that A)directs the flow of products from producers to customers. B)links producers to other marketing intermediaries. C)takes title to products and resells them. D)manages transportation and warehousing functions.

Description : A channel of distribution is a group of individuals and organisations that A)directs the flow of products from producers to customers. B)links producers to other marketing intermediaries. C)takes title to products and resells them. D)manages transportation and warehousing functions.

Last Answer : A)directs the flow of products from producers to customers.

Which is not a function of ERP? a. Human resource management b. financial c. warehousing d. None of the above

Description : Which is not a function of ERP? a. Human resource management b. financial c. warehousing d. None of the above

Last Answer : d. None of the above

Which is a function of ERP? a. Warehousing b. sales c. scheduling d. all of the above

Description : Which is a function of ERP? a. Warehousing b. sales c. scheduling d. all of the above

Last Answer : d. all of the above

Which is not a function of ERP? a. Warehousing b. sales c. scheduling d. None of the above

Description : Which is not a function of ERP? a. Warehousing b. sales c. scheduling d. None of the above

Last Answer : d. None of the above

Which is not a function of E‐commerce a. marketing b. advertising c. warehousing d. none of the above

Description : Which is not a function of E‐commerce a. marketing b. advertising c. warehousing d. none of the above

Last Answer : c. warehousing

Which is a function of E‐commerce a. marketing b. advertising c. warehousing d. all of the above

Description : Which is a function of E‐commerce a. marketing b. advertising c. warehousing d. all of the above

Last Answer : d. all of the above

Buffer stock operations are conducted by (1) Warehousing Corporation of India (2) State Trading Corporation of India (3) Food Corporation of India (4) Ministry of Agriculture

Description : Buffer stock operations are conducted by (1) Warehousing Corporation of India (2) State Trading Corporation of India (3) Food Corporation of India (4) Ministry of Agriculture 

Last Answer : Food Corporation of India

Can a repeating frame be created without a data group as a base?

Description : Can a repeating frame be created without a data group as a base?

Last Answer : No

Can one resize tablespaces and data files? (for DBA)

Description : Can one resize tablespaces and data files? (for DBA)

Last Answer : One can manually increase or decrease the size of a datafile from Oracle 7.2 using the command. ALTER DATABASE DATAFILE 'filename2' RESIZE 100M; Because you can change the ... UNLIMITED DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) ONLINE PERMANENT;

What view would you use to look at the size of a data file?

Description : What view would you use to look at the size of a data file?

Last Answer : DBA_DATA_FILES

How do you resize a data file?

Description : How do you resize a data file?

Last Answer : ALTER DATABASE DATAFILE RESIZE ;

How do you add a data file to a tablespace

Description : How do you add a data file to a tablespace

Last Answer : ALTER TABLESPACE ADD DATAFILE SIZE

Give the two types of tables involved in producing a star schema and the type of data they hold.

Description : Give the two types of tables involved in producing a star schema and the type of data they hold.

Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

Explain the difference between a data block, an extent and a segment.

Description : Explain the difference between a data block, an extent and a segment.

Last Answer : A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings ... that an object takes when grouped together are considered the segment of the database object.

Is it possible to insert comments into sql statements return in the data model editor?

Description : Is it possible to insert comments into sql statements return in the data model editor?

Last Answer : Yes

The join defined by the default data link is an outer join yes or no?

Description : The join defined by the default data link is an outer join yes or no?

Last Answer : Yes

Can a field be used in a report without it appearing in any data group?

Description : Can a field be used in a report without it appearing in any data group?

Last Answer : Yes

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Description : For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Last Answer : Yes

What are the characteristics of data files?

Description : What are the characteristics of data files?

Last Answer : A data file can be associated with only one database. Once created a data file can't change size. One or more data files form a logical unit of database storage called a tablespace.

What is a data segment?

Description : What is a data segment?

Last Answer : Each non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster's data segment.

How to define data block size?

Description : How to define data block size?

Last Answer : A data block size is specified for each Oracle database when the database is created. A database users and allocated free database space in Oracle data blocks. Block size is specified in init.ora file and cannot be changed latter.

What is data block?

Description : What is data block?

Last Answer : Oracle database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.