Securities in Cognos Framework Manager

By | BI - Cognos | 7min read | No Comments

Securities can be implemented in Framework manager. Package Security, Object Security, and Data Security, these are the securities we can implement in the Cognos Framework manager to restrict the objects and data to the selective users/user group and publish the package to the Cognos content store. This package can be used along with securities in the Cognos connection for building reports

Read More

SQL DDL COMMANDS

By | DB-SQL | 9min read | No Comments

SQL is Structured Query Language in Oracle, where we can perform DDL commands to create the tables and modify the structure of the table. Where we can truncate the data and we can drop the table and DB also using the DDL commands

Read More

Tableau Filters

By | Tableau | 7min read | No Comments

In Tableau, there are multiple ways you can filter and restrict your data. This can be either to improve performance, to give the viewer the correct information, or to highlight something important. These filters are applied in different orders, so depending on which kind of filter you apply – it can change the view and performance drastically

Read More

Oracle Data Guard and Active Data Guard

By | Oracle - DB | 6min read | No Comments

Oracle Data Guard technology used to create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Active Data Guard is super set of Oracle Data Guard. Active Data Guard enables the offloading of read-only operations, backups, and so on, to an up-to-date physical standby database while also providing disaster protection

Read More

Oracle Multitenant Architecture

By | Oracle - DB | 7min read | No Comments

From Oracle database 12c release, Oracle introduced multitenant architecture. With this architecture, Oracle Database can have one single container database (CDB) which consists multiple separate pluggable databases (PDB). Prior to 12c version, all the oracle databases were non-CDBs. This multitenant architecture solves a number of problems posed by the traditional non-CDB architecture. This document provides overview about this multitenant architecture

Read More

RESOURCES

Trending @ S-Square