Business Intelligence Triggers in SQL By Sohail Let's Have Fun with Triggers in SQL [wpdevart_youtube]BGJjLQr9Q2w[/wpdevart_youtube] What are Triggers? Triggers are a Block of Structure that executes when a DML Statement is performed or Executed. Triggers are fun to use but from a business point of view not...
Business Intelligence Cross Database Query in PostgreSQL By admin Cross – database query in PostgreSQL : We can join results from two different databases in PostgreSQL by using dblink/postgres_fdw( foreign database wrapper). Postgres_fdw : this feature is available in Postgres 9.3 onwards.By using we can connect to tables in...
Databases Batch Updation in Hibernate By Nikhilesh Batch Updation in Hibernate JDBC has long been offering support for DML statement batching. By default, all statements are sent one after the other, each one in a separate network round-trip. Batching allows us to send multiple statements in one-shot,...
Databases Batch Insertion in Hibernate By Nikhilesh Batch-Insertion in Hibernate To enable batch-processing to upload a large number of records into your database using Hibernate. If you are undertaking batch processing you will need to enable the use of JDBC batching. This is absolutely essential if...
Business Intelligence Beginners Guide to OLTP and OLAP By Sohail Beginner's Guide to OLTP and OLAP In this blog we will be looking into the introduction of OLTP and OLAP. How it is defined and how we can relate it to real-time Firstly, OLTP stands for On-line Transaction Processing and...
Business Intelligence Delete Duplicate Records Without Primary key By Nikhilesh Delete Duplicate Records From a Table without Primary key To find the duplicate records in the data and delete them Specifications: There is a table tbl1 with columns as follows The data is as follows: Query...
Databases Postgres Crosstab Function By Nikhilesh The crosstab function is used to produce "pivot" displays, wherein data is listed across the page rather than down. For example, we might have data like row1 val11 row1 val12 row1 val13 ... row2 val21 row2 val22 row2 val23 ......
Business Intelligence Helical Insight for ETL Tester (QA) By nitin sahu Helical Insight for ETL Tester (QA) Let's take an example that your ETL developer has just wrote an ETL script, which loaded the data into the Data Warehouse, few millions of records got inserted into the Data Warehouse. For QA,...
Databases Flexview CDC By Nikhilesh Flexview CDC Implementation This CDC utility identifies row changes in the database, and takes few action on them like writing them to a log file table or file. In order to update views incrementally, Flexviews needs to have detailed information...
Business Intelligence Creating a Project in SpagoBI Studio By Nikhilesh Creating a project in SpagoBI Studio SpagoBI Studio is an eclipse based BIRT reporting software and creating a project in SpagoBI studio is very much easy and recommended too as all our reports / documents will be organized in better...
Business Intelligence Creating a Folder in SpagoBI Server By Nikhilesh Creating a folder under Functionalities Tree in SpagoBI Server In general Spago BI uses its own functionalities tree which allows to better organize documents / reports by grouping them in folders. Although in built Folders are provided to organize (Analytical...
Business Intelligence How to Replace Various Characters Using Jasper Studio By Sohail How to Replace Various Unwanted Characters during Reporting Using Jasper Studio Reporting in Business Intelligence is the representation of Data in a more meaningful manner so at times we need to follow some few formats to make our data to...