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). […]
Modules of Knowledge Read More »
Big Data, ODI, SnowflakeEmployees at the Minneapolis Red Pill Analytics office recently had the luxury of sitting with Snowflake’s Steve Herskovitz for some on-site education. Among other things, one of my key takeaways from the exercise was how simple it is to query JSON data in the Snowflake Data Warehouse. The syntax is straightforward and makes the process
Kicking with JSON in the Snow Read More »
OBIEE, Snowflake, SQLFull Disclosure: I’ll be the first to tell you I’m not a DBA. I have a working knowledge of databases and “mainstream” SQL statements. I’m usually content to stay in my area of expertise and just query the data, make sure that the data is correct, and build some great content for clients. If you
BI Developer + Snowflake Root Access: A Love Story Read More »
Customer Service, Databases, Snowflake, SQLIn my last post, I discussed Snowflake’s unique cloud offering, and how to get it connected to OBIEE. In this post, I’ll give a brief overview of what Snowflake’s Time Travel feature is, how to use it from a query perspective, and how to integrate this feature into OBIEE. [pexyoutube pex_attr_src=”https://www.youtube.com/watch?v=fCjsUxbNmIs”][/pexyoutube]Where We’re Going… We Don’t Need
Back to the Future: Time Traveling with Snowflake Read More »
OBIEE, Snowflake