Advantages of data warehousing
State the different advantages of the data warehousing?
Expert
Following advantages are offered by the data warehousing:
a) It develops the quality and accessibility of the data. b) It capitalizes over the potential value of organization’s information. c) It combines the valuable archive data along with the latest data within the operational sources. d) It improves the amount of information which is available to the users. e) It reduces the requirement of the users in order to access the operational data. f) It decreases the strain on the IT departments, since they may gnerate one database to serve all the user groups.
Explain the Joiner transformation?
Provide a brief introduction on the term Star Schema?
Illustrate briefly the term DBMS?
Explain All Pages Locking in Sybase.
Describe why XML is a better markup language than HTML?
Explain the term Coalesce. Answer: Coalesce is also obtainable in Sybase, this function estimates the listed expressions and returns the first non-null value.
List out the main attributes of the data stage?
Explain the Combined Query?
Specify the various advantages of the Lookup persistent cache?
List out the different types of the data providers?
18,76,764
1931198 Asked
3,689
Active Tutors
1447514
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!