BUSINESS !NTELLIGENCE .

DM , DQ , Profiling , ETL , Performance tuning , Data warehousing , Visualisations . Overview of some tools and techniques.

a

Saturday, March 7, 2020

My Code repo

https://github.com/amol-vishwarupe

Posted by Amol VISHWARUPE at 6:06 AM

Newer Post Older Post Home

Translate

Informatica Cloud

Informatica Cloud Overview
Informatica Cloud ...Usage

Usual Scenarios

Concurrent Workflow
Concurrency with parameter file.
Indirect Load
Single source..Multiple files
File Watcher
Deployment....

Performance Tuning informatica

Different steps to tune different transformations
Informatica Performance Tuning Approach
Reusability
DTM ..Behind the scene
PDO at glance

Admin

Repository Backups .........................
Informatica Command Line reference
Basic setup to kick start command line utitlity PM...
Informatica default directory paths
Global Repository for re usability throughout BI D...
Repository Backup using command Line............

Test Automation

Automate PL/SQL Tests
Sample code
Maven PlugIn for utPLSQL

DataWareHousing Concepts

An Overview
Terminologies
Data Modeling phases
Types of facts and dimensions

Oracle PL-SQL

Oracle Architecture
CDC using Oracle
Using Oracle Sequences in transformations
Informatica and Materialized Views
Using Partition Swapping mechanism for loading hea...
Basic Query parsing steps Oracle takes before exec...
Bulk Load and Indexes ( Oracle Magazine )

Pl-SQL Deployment using LIQUIBASE

Liquibase for Deployment management
Getting Started

Live

Visitors

ELASTIC STACK

Home
Elastic Stack ?? What is it anyway
Let's start with elastic on Ubuntu
Some utilities for VM : PuTTY and Winscp
Accessing VM from PuTTY ( ports forward )
KIBANA . A very free dashboard tool from ELASTIC
Indexing ( Storing data ) in elastic
Simple python client
X-Pack ( Monitoring)

Useful tools

Visualisations

Tableau Public

Tableau TimeLine
Tableau at a Glance
Data Blending in Tableau
Calculated fields / in build functions
Forecasting and trending
Tableau help Link
My Tableau space

Data Quality / Data Profiling using talend

Data Profiling ...Getting Started
Talend for Data profiling
Profiling samples

Informatica

Home
Integrating JAVA classes in Informatica
Bulk Load and Indexes ( Oracle Magazine )
Different ways to Partition Pipeline
Pros n Cons Of Increasing commit interval
Using Oracle Sequences in transformations
Lookups , It's Types and It's Caches
Consuming WEB service in transformation
Repository Backups .........................
Different steps to tune different transformations
Informatica Performance Tuning Approach
What is Pushdown Optimization?
Global Repository for re usability throughout BI Domain of your company
Hashing in Informatica Using MD5......( Avoid too many column joins )
Informatica Command Line reference
Finding Middle Ranks using Rank Transformation
Basic Query parsing steps Oracle takes before executing Sql statement
How to Stop long running workflows after stipulated time
Using Partition Swapping mechanism for loading heavy fact tables
Informatica default directory paths
Basic setup to kick start command line utitlity PMCMD
Informatica and Materialized Views

Search This Blog

Blog Archive

▼ 2020 (11)
- ► June (3)
- ► May (2)
- ► April (2)
- ▼ March (4)

► 2018 (6)
- ► March (4)
- ► February (2)

► 2017 (1)
- ► July (1)

► 2016 (20)
- ► April (1)
- ► March (3)
- ► February (12)
- ► January (4)

► 2015 (7)
- ► December (5)
- ► October (1)
- ► May (1)

► 2014 (2)
- ► January (2)

Picture Window theme. Theme images by mariusFM77. Powered by Blogger.