I have been able to get my hands on a PI 7.11 SP08 machine and have successfully tested the PGP module as a start. In this blog, I will explain how to do PGP encryption using the SAP provided standard module PGPEncryption. For simplicity sakes, I have created a simple scenario as ...
How to Use Coalesce in PostgreSQL Say you're looking at a PostgreSQL integer column where some rows are null: selectday,ticketsfromstats; day|tickets---+---2018-01-01|12018-01-02|null2018-01-03|3 Instead of having that null, you might want that row to be0. To do that, use theco...
Purpose: Describe a method to address a common DW/BI problem of not having a matching row in a dimension for a given fact where the fact column is blank ('' ) whitespace. In general, we want to avoid returning null attribute values for a given entry in a fact. Just as a side note...
Why reprex? Getting unstuck is hard. Your first step here is usually to create a reprex, or reproducible example. The goal of a reprex is to package your code, and information about your problem so that others can run it…