Category: Uncategorized

DataTerrain Solution Series – Webinar Sessions

DatatTerrain Solution Series

Register here for DataTerrain Solution Series – Webinar Sessions How to build fast and efficient reports in Oracle HCM? No images? Click here Register View our list of Pre-built reports     Dataterrain Inc 228 Hamilton Ave, Palo Alto, CA 94301, USA www.dataterrain.com Preferences  |  Unsubscribe  

Read More +

Data Loading options in Snowflake

Snowflake

Snowflake provides multiple options for data loading. The best solution may depend upon the volume of data to load and the frequency of loading. Bulk Loading Using the COPY Command – This option enables loading batches of data from files already available in cloud storage, or copying (i.e. staging) data files from a local machine to an internal (i.e. Snowflake) cloud storage location before loading the data into tables using the COPY command.Bulk loading relies on user-provided virtual warehouses, which are specified in the COPY statement. Users are required to size the warehouse appropriately to accommodate expected loads.Continuous Loading Using Snowpipe – This option is designed to load small volumes of data (i.e. micro-batches) and incrementally make them available for analysis. Snowpipe loads data within minutes after files are added to a stage and submitted for ingestion. This ensures users have the latest results, as soon as the raw data is available.Snowpipe uses compute resources provided by Snowflake (i.e. a serverless compute model). These Snowflake-provided resources are automatically resized and scaled up or down as required, and are charged and itemized using per-second billing. Data ingestion is charged based upon the actual workloads.Note that it is not always necessary to […]

Read More +

Microsoft Power BI Gateway

Microsoft Power BI

Microsoft Power BI gateway is a software that is required to access data in a network. It acts as a gatekeeper for the on-premises data source. The request goes through the gateway if anyone needs to access on-premises data from a cloud or web-based app.There are 2 types of Power BI GatewaysStandard Mode – This gateway allows multiple data sources for more than one user. You can use the data in Power BI, Azure Analysis Services, Azure Logic Apps, Microsoft Flow, PowerApps, etc.Personal Mode – This data gateway is used by only one user to connect to different data sources. In this mode the user cannot share its user privilege with other users.You can use the data gateway in Power BI by following the four steps below: ● Install a gateway in your system. ● Add users to the gateway. ● Connect to on-premises data sources. ● Refresh on-premises data. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 200 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Overview of Snowflake Table Structures

Snowflake

All data in Snowflake is stored in database tables, logically structured as collections of columns and rows. Two principal concepts are used by Snowflake to physically maintain Table Structures for best performance. They are: Micro-Partitions Data-Clustering Micro-Partitions – Snowflake stores the data in a table using columnar fashion divided into a number of micro-partitions which are contiguous units of storage of size around 50 MB to 500 MB of uncompressed data. Unlike traditional databases, partitions aren’t static and aren’t defined and maintained by users but are automatically managed by Snowflake data warehouse in a dynamic fashion. A table can consist of thousands or millions of micro-partitions in Snowflake depending on the table size. This data will be broken into multiple micro-partitions in Snowflake. Data-Clustering – Data-Clustering is like the concept of sort-key available in most massively parallel processing (MPP) databases. Snowflake automatically does the job of clustering on the tables, and this natural clustering process of Snowflake is good enough for most cases and gives good performance even for big tables. However, if a user wants to do manual clustering, there is a concept of the clustering key which can be defined on the table by the user. Snowflake uses […]

Read More +

Oracle Fusion HCM Monthly Support

Extensive Oracle HCM Cloud support Full fledged expert support for developing new Oracle HCM Fusion extracts and reports. Export and Import with HCM extracts in Oracle Fusion. Audit / review security policies for HCM cloud and On premises HCM data. Consistent review and perform Oracle HCM performance fixes. 200 plus extensive and easily customizable prebuilt reports. Excellent Knowledge transfer.   Dataterrain Inc. 228 Hamilton Ave, Palo Alto, CA 94301, USA www.dataterrain.com Unsubscribe

Read More +

Limited time FREE offer from Dataterrain – OBIEE RPD MERGE TOOL

Limited time FREE offer from Dataterrain – OBIEE RPD MERGE TOOL DataTerrain’s RPD Merge Tool saves the hassles of managing multiple RPDs.The tool has an easy user interface with tree structure and search capabilities to help merge the right RPD source components to the right target for efficient merge and saves considerable time. DataTerrain’s RPD Merge tool has several additional features like RPD Diff, Patch, Schedule and Export which enhances the way you manage RPDs. While you can discover the differences between two RPD files (source and target) using our RPD Diff feature (with helpful color highlighting), the Patch feature helps you patch exactly, and only, what is relevant and required. This is easily done by selecting the objects from the source you want to patch, and moving them to the target RPD. The Patch RPD tab displays the RPD’s tree structure and provides a clear view of what you are moving from source to target DataTerrain’s RPD Merge tool offers the following benefits: Easily merge multiple RPD files in a single-run to produce a complete, merged output RPD, without missing any of the input files in the process. Accurately merge the RPD file ensuring that the result is in sync with the […]

Read More +

Human Capital Management Resources

Oracle HCM Taleo

Human Capital Management Resources for Modern Business The roles played by the Human Resource officers a few decades ago are not exactly the same today. A lot has changed with time; most importantly the evolution of technology. The use of data in planning, recruiting and management of employees is a must in today’s era. While some of the successful HR officers are already using data, a lot still lacks in terms of incorporation of this data with financial insights. Finance is the center of every business.

Read More +