Adglob Infosystem Pvt Ltd

Power BI

Post author:B D
Post published:August 17, 2021
Post category:Power BI
Post comments:0 Comments

Power BI is a Data Visualization and Business Intelligence tool that converts data from different data sources to interactive dashboards and BI reports. Power BI suite provides multiple software, connector,…

QlikView – Circular Reference

Post author:B D
Post published:August 17, 2021
Post category:QlikView
Post comments:0 Comments

Circular Reference occurs when we can traverse from one table to another using two or more different paths. This means you can join Table1 with Table2 directly using a column or…

Amazon RDS – Oracle DBA Tasks

Post author:S J
Post published:August 17, 2021
Post category:Amazon RDS
Post comments:0 Comments

As an industry leading database technology, oracle has many in-built features which makes it easy to manage the DBA activities, even in the cloud. The Amazon RDS oracle DB provides…

QlikView – Mapping Tables

Post author:B D
Post published:August 17, 2021
Post category:QlikView
Post comments:0 Comments

The mapping table is a table, which is created to map the column values between two tables. It is also called a Lookup table, which is only used to look…

QlikView – Master Calendar

Post author:B D
Post published:August 17, 2021
Post category:QlikView
Post comments:0 Comments

In QlikView, many times we need to create a calendar reference object, which can be linked to any data set present in QlikView's memory. For example, you have a table…

QlikView – Concatenation

Post author:B D
Post published:August 17, 2021
Post category:QlikView
Post comments:0 Comments

The concatenation feature in QlikView is used to append the rows from one table to another. It happens even when the tables have different numbers of columns. It differs from…

Amazon RDS – Oracle DB Data Import

Post author:S J
Post published:August 17, 2021
Post category:Amazon RDS
Post comments:0 Comments

To import data into the RDS oracle database or export data from it, we need to consider the size of the data involved and use a appropriate technique. The Sql…

QlikView – Keeps

Post author:B D
Post published:August 17, 2021
Post category:QlikView
Post comments:0 Comments

The keep command in QlikView is used to combine data from two data sets keeping both the data sets available in memory. It is very similar to joins we covered…

Amazon RDS – Oracle Connecting to DB

Post author:S J
Post published:August 17, 2021
Post category:Amazon RDS
Post comments:0 Comments

To connect to Amazon RDS Oracle DB we need a client software. In this case we use Sql Developer. Install it using the link SQL Developer . After it is successfully installed…

QlikView – Joins

Post author:B D
Post published:August 17, 2021
Post category:QlikView
Post comments:0 Comments

Joins in QlikView are used to combine data from two data sets into one. Joins in QlikView mean the same as in joins in SQL. Only the column and row…