DDL and DML Operations in MongoDB

MongoDB is an open-source document database that provides high performance, high availability, and automatic scaling. A record in MongoDB is a document, which is a data structure composed of field and value pairs As: { name:”ABC”, age:18, gender:”Male” } MongoDB is a document-oriented DBMS. Think of MySQL but with JSON-like objects comprising the data model, …Read More

Cookies with CORS

Cookies with CORS CORS stands for Cross-Origin Resource Sharing and this is what wikipedia has to say about it. Cross-origin resource sharing (CORS) is a mechanism that allows many resources (e.g. fonts, JavaScript, etc.) on a web page to be requested from another domain outside the domain from which the resource originated. Once CORS is …Read More

Calling JRXML inside HDI(Helical Dashboard Insights) : –

             Calling  JRXML  inside  HDI(Helical Dashboard Insights) : – This blog will teach you how to call JRXML inside HDI(Helical Dashboard Insights) : – To call JRXML inside Helical Dashboard Insights , we need 4 files required for HDI and one JRXML file. I have created one folder named “JRXML” …Read More

Creating Dynamic Drop Down List in Talend

Creating Dynamic Drop Down List in Talend Created a sample job to retrieve the records from a particular table only by selecting the table name from a drop down list. First we have to create tables and load the data into the database. We have to get these tables in a particular database as drop down …Read More

Types of CDC supported by Talend Enterprise Edition

Types of CDC supported by Talend Enterprise Edition :   CDC (Change Data Capture ) : The CDC architecture is based on the publisher/subscriber model. The publisher captures the change data and makes it available to the subscribers. The subscribers utilize the change data obtained from the publisher. The main tasks performed by the publisher …Read More

What is Software Testing? Why is software testing necessary?

What is Software Testing? Nowadays, Software testing plays an important role,which helps to improve the quality, reliability and performance of the software applications. Usually software testing is considered as one phase of the software development life cycle (SDLC). Software testing is the process in which the defects are identified, isolated and subjected for rectification to …Read More

SQL Event Scheduling

SQL Event Scheduling   Event is responsible for making sure that a specified routine (section of query code) is executed at regular intervals that is specified by the user. An example of use of an Event would be as follows : A retail store owner wants to see his remaining stocks in his store, in …Read More

Connection Time Out in AWS EC2

Connection Time Out in AWS EC2   Possible reasons for timeout when trying to access EC2 instance The most likely one is that the Security Group is not configured properly to provide SSH access on port 22 to your i.p. The local firewall configuration does not allow SSH access to the server. The server is …Read More

Create a row grouping in Table Component (Jasper Report)

Create a row grouping in Table Component (Jasper) Consider an example currently you are showing the data as shown in below using tabular component. Example: State Person Name Tax Amount Iowa PQR 10,000 Iowa XYZ 15,248 Utah ABC 14,245 Utah DEF 13,256 Wisconsin GHI 12,789 Wisconsin JKL 11,100 But If you want to show the …Read More

I-Report Bands

                                                                                                        I-Report Bands   A jasper report is composed by a set of sections named as “bands”.  Every band contains few properties such as height. Band height should be greater than 0, otherwise it will never be visible to user.  The band height can grow if elements inside it are stretched. Default Bands in …Read More