December 15, 2016

|

by: pete.scott

|

Categories: GitHub, ODI

Last time I went through some of the basics about getting the latest patch-set of ODI to connect to a GitHub.com VCS repository. Today I will talk a little about versioning our ODI development in Git. Navigator The first point to make is that we can select the objects we wish to version-track in Git, […]

September 30, 2016

|

by: pete.scott

|

Categories: Big Data, ODI, Snowflake

One of the features of Oracle Data Integrator that sets it apart from other data integration tools is the use of Knowledge Modules to define how parts of the data integration process occur. The developer creates a data load mapping from sources, joins, filters and targets (and in ODI 12 even more components are available). […]

April 25, 2016

|

by: pete.scott

|

Categories: ODI, Tips

At work last week I lifted the covers on the Red Pill Analytics Slowly Changing Dimension ODI IKM for Oracle. If you haven’t heard about this knowledge module, it was specifically written to take a dimension source table and transform it to a slowly changing dimension target table. Unlike other similar IKMs, this module uses […]

April 14, 2016

|

by: pete.scott

|

Categories: ODI, Tips

In the depths of time before ODI 12c, ODI Studio had a fairly simple canvas to design our interfaces. We dropped on our datastores (tables) and then dragged columns between tables to create joins, and columns to the canvas to make filters. If we needed to use expressions we just typed them on the target […]

February 18, 2016

|

by: pete.scott

|

Categories: ODI

This is my first contribution on Medium under the Red Pill Analytics brand. I hope I will keep up the high standards of my co-workers. One of the projects I have been working on recently had a requirement to enrich some data by bringing back additional information from a legacy system, For various reasons they […]

July 12, 2015

|

by: Kathryn Watson

|

Categories: ODI, Tips

If you’ve ever looked at the ODI Menu Bar or File menu, you’ve seen that there are two separate save options: Save and Save All. Big deal, right? Everyone knows the difference between Save and Save All. (If you don’t, Save will save only one object at a time, the active object you have open/are […]

July 9, 2015

|

by: Kathryn Watson

|

Categories: ODI, Tips

ODI 12c Studio slow to respond? Receiving low or out of memory warnings? ODI 12c Studio crashing? With an out-of-the-box ODI 12c installation, the memory allocated to ODI Studio is generally too low to handle complex tasks — multiple modifications on a complex mapping, regenerating multiple scenarios, prolonged development sessions, etc. When completing such complex tasks over […]

0
0
without
https://redpillanalytics.com/wp-content/themes/vanguarda/
https://redpillanalytics.com/
#991913
style1
paged
Loading posts...
/home/redpil9/public_html/
#
on
none
loading
#
Sort Gallery
on
yes
yes
off
Newsletter Input text
off
off