What is repository
Explain what is meant by the repository and what does it consists of?
Expert
It is defined as the relational data account developed on the database such as MS-Access, Oracle, Informix, DB2 and so on when the BO gets installed. It will have all the BO system tables, metadata regarding the designer, Information about the universes, the actual universes, user documents and mainly importantly security information.
Explain about the stored-procedures and its advantages.
Explain the terms SQL Server and adaptive server enterprise?
Explain the term object?
Explain the term lattice of cuboids in brief.
Illustrate the term data mart. What do you mean by it?
Explain the term local container and shared container?
Explain offline /online modes in the Designer?
How can we remove duplicate rows from the flat file?
What is meant by the Data warehouse?
Explain some of the ETL Tools?
18,76,764
1961585 Asked
3,689
Active Tutors
1452036
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!