Operational data stage and data warehouse
Explain the term operational data stage (ODS) and data warehouse?
Expert
A data ware house is defined as the decision support database for the organisational needs. It is non volatile, subject oriented, integrated, time variant collection of the data.
a) ODS or Operational Data Source refers to an integrated collection of the related information. It consists of the maximum 90 days information.
b) ODS is nothing but operational data store, which is the part of the transactional database. This db keeps the integrated data from different db and enables common operations across the organisation. For example: banking transaction.
c) In simple terms, ODS is the dynamic data.
How can we do unit testing into the informatica? How to load data in the informatica?
Explain the security aspects of stored procedures.
Explain the connected and unconnected transformation?
Explain the terms SQL Server and adaptive server enterprise?
Illustrate the term data mart. What do you mean by it?
Illustrates storing of data in stored procedures increase the access time?
When is a functional dependency F considers as to be minimal?
Flexibility due to Cloud computing: Company achieves the flexibility to share data over the clouds. It also gets help in talent acquisition process.
Write down the importance for using repository connectivity?
Which member function places a new node on the end of the linked list? Answer: appendNode(): This member function places a new node on the end of t
18,76,764
1931057 Asked
3,689
Active Tutors
1432376
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!