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 15, 2017

|

by: Lauren Prezby

|

Categories: Events, Red Pill Analytics' Tips, Red Pill News

Fall is here and that means a trip to San Francisco is on the calendar for Red Pill Analytics. Once again, we are thrilled to be joining an amazing group of presenters at Oracle’s largest conference of the year, Oracle OpenWorld/JavaOne. Red Pill Analytics has six sessions, three at Oracle OpenWorld and three at JavaOne. […]

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 […]

January 24, 2017

|

by: Fahd Saeed

|

Categories: Red Pill Analytics' Tips, Tips

We all get by with a little help from our friends. Let us share a tech tip with you and offer you an opportunity to learn more from the Red Pill Analytics team. I came across a table with some troublesome duplicated rows and wanted to remove these dups so I used an old query of […]

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