Business Intelligence How to use Custom Component in Jaspersoft Studio By admin How to use Custom Component in Jaspersoft Studio: This Blog will teach you how to use Custom component in Jaspersoft studio. A Custom component allows the BI Developer to enhance the functionality of Jasperreports engine by adding some custom visualized...
Business Intelligence MySQL C – API Programming By Nikhilesh MySQL C - API programming MySQL is a leading open source database management system. It is a multi user, multithreaded database management system. MySQL is especially popular on the web. Basic Structure of C Programs that uses MySQL C API 1....
Databases Best Practices to Use while Writing SQL By Nikhilesh Best Practices to Use while Writing SQL Always use table aliases when your SQL statement involves more than one source If more than one table is involved in a from clause, each column name must be qualified using either the...
Databases Data Base Partitioning By Nikhilesh Partitioning enhances the performance, manageability, and availability of a wide variety of applications and helps reduce the total cost of ownership for storing large amounts of data. Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces,...
Business Intelligence Sorting Data In Mysql Based On Field Value Of a column By admin This blog will teach you how to sort Data In Mysql Based On Field Value Of a column We can sort data based on field value of a column by using ORDER BY FIELD () in mysql. Database : world...
Business Intelligence ETL Project development using Agile-Waterfall-ETL Framework method By Nikhilesh ETL Project development using Agile-Waterfall-ETL Framework method ETL projects development while performing all the following tasks takes very long time. But, using Agile-Waterfall-Framework method could enhance the speed, quality and delivery of ETL projects. Various tasks which are required to...
Databases Create Dynamic Query In MYSQL Using Stored Procedure By admin This blog will teach you how to create dynamic query in mysql using stored procedure. Dynamic SQL is a programming technique that enables us to write SQL statements dynamically at run time. Dynamic Queries are not embedded in the source...
Business Intelligence Table Expansion in Pentaho CDE By Nikhilesh Hello, we are now working on Table Expansion property of Pentaho CDE. Simple, expanding a Main Table on click and render relevant data in Any Chart / table. Make data easy with Helical Insight. Helical Insight is the world's best...
Business Intelligence Talend connection with SQL Server using Windows Authentication By Nikhilesh Setting up SQL Server connection using Windows Authentication with Talend Open Studio SQL Server database connection from talend is straight forward. But when the database is setup with windows authentication, the conventional method does't work. Talend is yet to find...
Business Intelligence DATA VAULT MODELING By Nikhilesh DATA VAULT MODELING Data Vault Modeling is a database modeling method that is designed to provide long-term historical storage of data coming in from multiple operational systems. It is also a method of looking at historical data that, apart from...
Databases Different types of models used by databases By nitin sahu There are a lot of databases out there in the market, lets understand the models types and the corresponding usage. Different types of models used by databases • Relational DBMS • Wide column stores • Content stores • Document stores ...
Business Intelligence Finding MySQL Database Size By Nikhilesh Finding MySQL Database Size Here’s the SQL script to list out the entire databases size. SELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema; SELECT TABLE_NAME,...