Lateral subqueries in Postgres

Lateral subqueries in Postgres Postgres has feature to use value from preceding table using keyword lateral. This is used for cross-referencing. means Subqueries appearing in FROM can be preceded by the key word LATERAL. This allows them to reference columns provided by preceding FROM items. (Without LATERAL, each subquery is evaluated independently and so cannot …Read More

Verification and Validation in Software testing

 Verification and Validation in Software testing Before getting into the various strategies of testing we must understand the process of verifying and validating the software code. Verification and validation is the generic name given to checking processes which ensure that the software conforms to its specification and meets the needs of the customer. The system should be verified and validated at each …Read More

JSON Schema

JSON Schema What is JSON? JSON Stands for JavaScript Object Notation. This is a structure that can be used to store data as in key value pair separated by : . JSON can be used to transfer data to and fro any network. It is a simple plain text, it can be consumed by any …Read More

jQuery tips

We often write traditional code by not knowing limitations and performance issues. In this post, I’m going to discuss few concepts of jQuery with which you can increase performance of those methods. It is always preferable not to interact with the DOM more frequently. This reduces the performance. For example: var divs = “”; for …Read More

Logout Page Customization in Jaspersoft :

                                                           Logout Page Customization in Jaspersoft : When we click on Log out link in jaspersoft or when the session expires , it is always redirected to Jaspersoft Login Page. Now if we want to see any other page or let say we want …Read More

Command line execution and Redirection Process in Pentaho (Kettle)

Command line execution and Redirection Process in Pentaho (Kettle) Command line execution in Pentaho (Kettle) : Pentaho provides two commanline utility tools to execute your job/transformation from outside of spoon. 1.Pan: Pan is the PDI command line tool for executing transformations.Pan runs transformations, either from a PDI repository (database or enterprise), or from a local …Read More

EDI – Electronic Data Interchange

Introduction Standardisation is needed in every field to create uniformity. Same is the case with data exchange, Without a standard format, each company would send documents using its company-specific format and, much as an English-speaking person probably doesn’t understand Japanese, the receiver’s computer system doesn’t understand the company-specific format of the sender’s format . A …Read More

Beginners Guide to Understanding Cross Join

Beginners Guide to Understanding Cross Join In my previous Beginners Guide we talked about Types of joins i.e. Inner Join, Left and Right Join but today we will be talking about cross join which happens to be more interesting to me than any other joins and happens to be helpful in real time for me. …Read More

Getters and Setters of JavaScript for a Java Programmer

Getters and Setters of JavaScript for a Java Programmer In this blog article I will discuss about an important feature of JavaScript – property Getters and Setters. Getters and Setters help you to achieve data encapsulation. The write up is not going to be a comprehensive tutorial but, will provide some insights to understand the …Read More

Why build a Data warehouse?

Why build a Data warehouse?   Often when we talk about implementing BI, the first thing we need to look at is how and where is the data? Is it scattered? Is it easy to report on? With this we often need to know if we need to build a reporting database or a data …Read More