<!DOCTYPE html> <html> <head> <style> #myImg { border-radius: 5px; cursor: pointer; ...
Read More
Business Days in Current Month [Excluding Sat Sun]
You can use the following SQL to get the number of working days (not including sat and sun) of the current month SELECT CO...
Read More
Heat Map using Google API - OBIEE 11G,12C.
Hi All, Wanted to share the steps that you can do to create a dynamic heat map to mark Geo coordinates on google map. The heat map colors...
Read More
OBIEE Prompt for BIP Report - Passing Multiple Values along with Passing All Values
For the OBIEE prompts to be used for BIP reports and to pass (All Column Values) and also multi select you can use the following SQL in the...
Read More
Display Previous N period in MON-YY format
SELECT TO_CHAR(ADD_MONTHS(SYSDATE, -level), 'MON-YY') AS Previous_Period FROM dual CONNECT BY LEVEL < 5 order by (TO_CHAR(A...
Read More
Informatica MDM - A brief Introduction
Tokenization process in Informatica MDM? How to create a basic Mapping in Informatica MDM? How to Unmerge records in Informat...
Read More
How to handle Early Arriving Facts and Late Dimension in ODI
Hi All, I read an article in the Oracle Blogs about implementing the early arriving facts or late dimensions and this is a re creation of t...
Read More
Early Arriving Facts or Late Arriving Dimensions
Early Arriving Fact Also known as Late Arriving Dimensions. An early arriving fact takes place when the activity measurement arrives at...
Read More
How to Implement CDC in ODI 11g
Changed Data Capture (CDC) allows Oracle Data Integrator to track changes in source data caused by other applications. When running integr...
Read More
Change Data Capture in ODI
Changed Data Capture (CDC) allows Oracle Data Integrator to track changes in source data caused by other applications. When running integr...
Read More
ODI - Using ODI user function with Interface or Package
Hi, It is very common to use ODI user functions during the transformation and the below steps explains how a user function can be created...
Read More
Subscribe to:
Posts
(
Atom
)