It depends on the type of business that demands a cloud setup. Suppose if the subscription on a public cloud for an application that is to be deployed on OS images is proving to be more costly then to buy some new datacenters and maintain them. Then obviously the a private cloud has to be setup instead of a public cloud. This public clouds follow utility billing methodology as electricity bill for example.

Cloud data center doesn’t require experts to operate it, but it requires skilled people to see the maintenance, maintain the workloads and to keep the track of the traffic. The labor cost is 6% of the total cost to operate the cloud data center. Power distribution and cooling of the datacenter cost 20% of the total cost. Computing cost is at the end and is the highest as it is where lots of resources and installation has to be done. It costs the maximum left percentage.

Data warehouse

- It is a decision support database system for the purpose of organizational needs. 

-It is non volatile, integrated and time variant collection of data

Operational Data Stage

- It is an integrated collection of information. 

-It can contain 90 days of information at maximum.

-ODS supports dynamic data.

-Daily loading is known as incremental load.

-When data is selected from source, selected records are loaded between timestamp of last load and the current time 

-The parameter that are passed to perform are last loaded date and current date

-The first parameter is the stored last run date is read through job parameters

-The second parameter is the current date

Sequence numbers can be generated in Datastage using certain routines. They are

-KeyMgtGetNextVal

-KeyMgtGetNextValConn

Datastage has two components

-Client Components – Designer, Director, Manager and Administrator

-Server Components – Server, Repository and Plug-ins.

- A tool for designing Extraction, Transformation and Loading

- An ideal tool for data integration projects system migrations

- Importing, extracting and creating metadata are within these jobs

- Data stage allows scheduling, monitoring and running the jobs 

- Allows to administer the development and execution in a single environment

- Scheduling and executing the batch jobs.

- Configuring, starting and stopping the real-time services

- Adapters configuration and managing them.

- Repository usage, Job Server configuration.

- Access Server configuration.

- Batch job publishing.

- Real-time services publishing through web services.