Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
There are various requirements of data staging which are as follows −Productivity support − Any system it is decide to implement needs to support basic development environment capabilities such as code library management check-in/check-out, version control, and production and development system constructs. Initially, and for smaller projects, these can be implemented through a standards document, a process description, and a set of standard directories.Usability − The data staging system also must be as usable as possible, given the underlying complexity of the task. In the last few years, this has translated into a graphical user interface. A good interface can ... Read More
There are various criteria for selecting the data sources which are as follows −Data accessibility − If two possible feeds exist for the data, one is stored in binary files maintained by a set of programs written before the youngest project team member was born and the other is from a system that reads the binary documents and supports more processing, then the decision is obvious.Data accuracy − As data is passed from system to system, many modifications are made. Sometimes data elements from other systems are added, and sometimes existing elements are processed to create new elements and other ... Read More
There are various tools to facilitate the project are as follows −Data Warehouse Bus Architecture Matrix − The matrix produced by the design team in their internal meetings can be cleaned up and used as a presentation support for meetings with several designers, authority, and end-users. The matrix is very useful as a high-level introduction to the design. It provides each audience a look of what the eventual function of the data warehouse will develop into.Fact Table Diagram − After preparing Bus Architecture the matrix, it can prepare a logical diagram of each completed fact table. The fact table not ... Read More
There are the following methods for designing an Individual Fact Table which is as follows −Choosing the Data Mart − It can be choosing the data mart in the simplest method is the same as choosing the legacy source of information. Typical data marts involve purchase orders, shipments, retail sales, payments, or user connections. These can be an instance of single-source data marts.In some cases, it can define a data mart that should contain multiple-legacy sources. The instance of a multiple-source data mart is user profitability, where legacy sources that define revenue should be combined with legacy sources that represent ... Read More
Dimensional modeling is a logical design method that follows to present the data in a standard structure that is perceptive and enables high-performance access. It is genetically dimensional and observes to a discipline that needs the relational model with several restrictions.Each dimensional model is composed of one table with a multipart key, known as the fact table, and a group of smaller tables known as dimension tables. Each dimension table has an individual element primary key that correlates to one of the elements of the multipart key in the fact table. This distinctive star-like structure is known as star join. ... Read More
There are various approaches of Business Dimensional Lifecycle which are as follows −Project planning − Project planning addresses the description and scoping of the data warehouse project, such as readiness evaluation and business justification. These are the tasks because of the high visibility and costs related to data warehouse projects.Project planning targets resource and skill-level staffing requirements, coupled with project task assignments, continuation, and sequencing. The resulting integrated project plan recognizes all tasks related to the Business Dimensional Lifecycle and the parties included. It can deliver as the foundation for the ongoing administration of the data warehouse project. Project planning ... Read More
Data staging is a major process that includes the following subprocesses which are as follows −Extracting − The extract step is the first phase of getting information into the data warehouse environment. Extracting defines reading and learning the source data, and copying the elements that are required to the data staging area for more work.Transforming − Because the data is extracted into the data staging area, there are several possible transformation processes, are as follows −It can be cleaning the data by correcting misspellings, resolving domain conflicts (including a city name that is inconsistent with a postal code), dealing with ... Read More
The cost of conductor material required for designing a transmission line is a very considerable part of the total cost of a transmission line. Therefore, the determination of proper size of the conductor for the transmission line is very important. The proper size of the conductor for transmission line is determined by the Kelvin’s law (given by Lord Kelvin in 1881).The Kelvin’s law states that the most economical area of conductor is that for which the total annual cost of transmission line is minimum.The total annual cost of the transmission line can be divided into two parts viz. −Annual charges ... Read More
Depreciation of Power Plant EquipmentThe reduction in the value of the equipment and other property of the power station every year is known as depreciation. Therefore, a suitable amount, called depreciation charge, must be set aside annually so that by the time the life span of the power plant is over, the collected amount equals to the cost of the replacement of the power plant.Diminishing Value Method of DepreciationIn the diminishing value method for calculating the depreciation, the depreciation charge is made every year at a fixed rate on the diminished value of the equipment, i.e. the depreciation charge is ... Read More
Overhead DC Transmission SystemThe overhead transmission system is the one in which the conductors are hanged with the help of pole supports. When the transmission lines carry direct current, then the system is called the DC transmission system.There are three types of overhead DC transmission systems viz. −Two wire DC system with one conductor earthedTwo wire DC system with mid-point earthedThree wire DC systemConductor Material Required in Two-Wire DC System with One Conductor EarthedConsider a two wire DC system with one conductor earthed as shown in Figure-1. Here, one is the positive wire and the other is the negative wire ... Read More