This week we provided training sessions on SQL Data Types under database section. Data Propagation, Data Quality, Data Pivot, Data Partitioning, Data Normalization and Data Optimization under datawarehouse.

Knowledge Base Latest Updates

Data Warehouse

What is Data Propagation
Data Propagation is the distribution of data from one or more source data warehouses to one or more local access databases, according to propagation rules. Data warehouses need to manage big bulks of data every day. A data warehouse may start with a few data, and starts to grow day by day by constant sharing and receiving from various data sources.

What is Data Quality
Data Quality indicates how well data in the data resource meet the business information demand. Data Quality includes data integrity, data accuracy, and data completeness. Today’s business organization cannot function at its optimum without relying on information. Data sources supplying information such as data warehouses and data marts are fast

What is Data Pivot
Data Pivot is a process of rotating the view of data. In databases where there is high level volume of data, it is often very difficult to get a view of a particular data or report. A pivot table helps overcome this problem by displaying the data contained in the database by means of automated calculations which are defined in a separate column

What is Data Partitioning
Data Partitioning is the formal process of determining which data subjects, data occurrence groups, and data characteristics are needed at each data site. It is an orderly process for allocating data to data sites that is done within the same common data architecture. Data Partitioning is also the process of logically and/or physically partitioning

What is Data Normalization
Data Normalization is a process to develop the conceptual schema from the external schema. In its very essence, data normalization is the process of organizing data inside the database in order to remove data redundancy. The presence of many redundant data can have very undesirable results which include significant slowing of the entire computer

What is Data Optimization
Data Optimization is a process that prepares the logical schema from the data view schema. It is the counterpart of data de-optimization. Data optimization is an important aspect in database management in particular and in data warehouse management in general. Data optimizations is most commonly known to be a non-specific technique used by several

Database

SQL Data Types
SQL Data Types Overview In SQL, as in many other programming languages, every piece of data has a particular type. For example, 11 is an integer, and “Wall Street” is a text string. The SQL standard defines many data types to accommodate almost any type of data. Some cases arise where the SQL standard does not adequately support certain Read more

GeekInterview Talk Forum Discussions

How to create materialized view?
by priyasp_msit
How to create materialized view? What is the difference between view and materialized view?

Inherit private members of base class
by rahul.gupta
Explain why private members of base class cannot be inherited in derived class if derived publicly.

When is an object ready to be garbage collected
by raghavrules
When is an object ready to be garbage collected by the compiler. Is it the same way all the time?

How to create a Data Driven Test in Rational Robot
by ravisuriya
I Need to automate the test for Data Driven Test i.e., like accessing the values from Data Tables in QTP.

How to convert system date to specified date in QTP 9.2?
by mythreyi
I am trying to convert system date into a specified format (like mm/dd/yy) in QTP 9.2. Can anyone tell me how this could be done?

GeekInterview Blog Articles

Mastering the Art of Team Building
By Chandra Vennapoosa
No business or industry could really make it big without the cooperative efforts of its supervisors and workers. The demands of modern business as a fast paced environment has made teamwork and cooperation an essential part of business success. Recent business developments show that there is a move towards mergers and free markets are being established.

Surviving the First Day at Work
By Chandra Vennapoosa
Getting hired is not the sole objective of career development. In fact, it is just a gateway for the real struggle. If you are serious about your career development you will certainly have to go through challenging times in order to move up the career ladder.

10 XML Editors You Can Try Out
By Lokesh
XML has a very big role in developing an Ajax based application. Some developers are fast and smart enough to build Ajax with XML without any third party help. But there are developers who need all the help they can get not only for JavaScript but for XML as well. The following are some of the XML editors you can use for faster development.

Ajax Articles

Enterprise Ajax 4.2 for Java Released
Misusing XMLhttprequest in a Website
ECMAScript 4 - The Future of JavaScript
Google’s Updated Ajax Search API
Build Dynamic Data-driven Grids
Web Developer in Austin, Tx
Separating Layout and Logic in Ajax Based Application

Latest Tutorials (Partner Site Resource Links)

Service Oriented Java Business Integration Review
Introduction If you’ve read through the texts which give you an introduction to SOA or Web Services, you will often find them to be quite frustrating, and the reason for this is because they spend too much time referencing business processes which are elaborate, and which can be built on top of them. Since SOA, along with WSDL, are now independent of a programming language, many are wondering whether or not they should pick Java. Turning to this book can give you information on this.

Linux Thin Client Networks Design and Deployment Review
Introduction This book is written by David Richards, a veteran Linux thin client network designer. Designed for System Administrators, Linux Thin Client Networks Design and Deployment goes over the concepts which are related to thin client networks, as well as issues related to design and implementation. This book includes a sizeable number of how-to guides which are step-by-step, and it covers the various elements which are involved with the implementation of the thin client network which is dependent on the open sourced software.