Differences between a data warehouse and data mart
Write a brief note on the differences between a data warehouse and data mart?
Expert
A data warehouse is for the enterprise and contains numerous subjects. A data mart is for a specific functional region and focuses on one subject. A data warehouse is data-oriented and flexible and contains detailed historical data. A data mart is project-oriented and restrictive and contains some historical data.
Elucidate how can we get first 100 rows from flat file in the target?
Name the methods and types of Collision Resolution Techniques used in each of the type?
Explain the term DataStage and Informatica?
What do you understand by the term foreign key in DBMS, and why is it employed for?
Why we use Context? And explain the LOV?
What are the purposes of using lookups?
How can we increase the performance within the Data Stage?
Explain the term Super servers?
Give a brief introduction of the term surrogate key?
Explain the Slice and Dice attribute in the Business Objects?
18,76,764
1928972 Asked
3,689
Active Tutors
1426242
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!