October 11, 2017

|

by: Mike Fuller

|

Categories: Red Pill Analytics' Tips, Snowflake, Tips

Snowflake Data Warehouse release 2.11 (September 7, 2017) included the addition of an OVERWRITE parameter for the INSERT command. INSERT OVERWRITE effectively consolidates two commands, TRUNCATE TABLE and INSERT, into one. INSERT OVERWRITE also deletes the file load history and retains access control privileges on the target table; both of which are not insignificant details. […]

September 14, 2017

|

by: pete.scott

|

Categories: Oracle 12c, SQL, Tips

When I start a new ETL project I often find it useful to have some idea how the source tables relate to each other. If I’m lucky there is documentation to guide me or even a diagram showing me how the tables link up (I do dream a lot). Of course, I could pull the […]

June 25, 2017

|

by: emily.carlsen

|

Categories: Analytics, Events, Tips

Editors Note: This year, Red Pill Analytics is the Analytics Sponsor at ODTUG Kscope17. Our company motto is #challengeeverything – so we knew we wanted to do something different and unexpected while at the conference. What we eventually landed on was creating Analytics Stations using IoT technologies to show how an old school object, like […]

June 23, 2017

|

by: emily.carlsen

|

Categories: Events, Tips

Editors Note: This year, Red Pill Analytics is the Analytics Sponsor at ODTUG Kscope17. Our company motto is #challengeeverything – so we knew we wanted to do something different and unexpected while at the conference. What we eventually landed on was creating Analytics Stations using IoT technologies to show how an old school object, like […]

March 31, 2017

|

by: Phil Goerdt

|

Categories: Exalytics, OBIEE, Oracle 12c, Tips

Red Pill Analytics recently performed the installation of OBIEE 12c on an Exalytics machine for one of our customers. There is no option to use the Domain Management Utility for installing OBIEE 12c… that’s still only capable of installing OBIEE 11g. Therefore OBIEE 12c is a manual install on Exalytics, but it’s very similar to installing OBIEE […]

March 31, 2017

|

by: stewartbryson

|

Categories: Events, Tips

GaOUG Tech Days is just around the corner: May 9-10 to be exact. We have an incredible venue in Downtown Atlanta called the Loudermilk Center with exceptional event space throughout. We have a great collection of national speakers from the Oracle Community, so the locals in Atlanta can get a feel for larger, more national conferences […]

March 22, 2017

|

by: Phil Goerdt

|

Categories: OBIEE, Red Pill Analytics' Tips, Tips

Let’s pretend that you need to change ports within your OBIEE 12c instance due to new applications that natively install into ports that OBIEE is running. Or maybe you want to have the ports be the same as the OBIEE 11g ports. Whatever the reason, how do we go about changing the ports within the […]

March 7, 2017

|

by: Phil Goerdt

|

Categories: OBIEE, Oracle 12c, Tips

Recently I had to verify the version of an OBIEE installation for a client. As I was already ssh-ed into the Linux machine, I figured there was a way to determine the version without having to log into the presentation server. Turns out, I was right, but for thoroughness sake, I’ll cover both approaches. Using […]

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