Posts Tagged ‘Oracle’

What is a Slowly Changing Dimension? Slowly Changing Dimension (SCD) is a dimension that allows us to store and manage both current and previous data over time in a data warehouse. It is considered and implemented as one of the most critical ETL tasks in tracking the history of dimension records. There are three types […]

Each month Oracle provides “What’s New” publications describing new features across the EPM Cloud stack. Within this publication, Oracle also provides notices about important changes either applied to that month’s release or planned for the future (the intent being to give customers ample time to plan for & address the change). We highly recommend service […]

Are you a part of the Human Resources team, which is tasked with reporting on Equal Employment Opportunity? Are you an Oracle Human Capital Management consultant tasked with configuring the environment setup of this report? The goal of this blog is twofold: demystify EEO reporting by defining the various reports, and outline EEO-1 reporting setups […]

In D & A Projects, building efficient SQL Queries is critical to achieving the Extraction and Load Batch cycles to complete faster and to meet the desired SLAs. The below observations are towards following the approaches to ensure writing SQL queries that meet the Best Practices to facilitate performance improvements. Tuning Approach Pre-Requisite Checks Before […]

Can you believe it?… January is behind us and February is here! And with February comes Valentine’s Day… (just a friendly reminder for those of us who tend to mistakenly overlook this holiday 🙂 ). But lucky for customers, Oracle is not getting distracted by Cupid and is instead providing a laundry list of enhancements […]

At Perficient, our people are at the heart of what we do. We love what we do and where we work, contributing to our collaborative, open, and friendly culture. Our culture is one of the main reasons Perficient continues to be recognized as a “Top Workplace” in key markets across the U.S. Perficient invests in […]

2023 is going to be a challenging year for CFOs. Rising inflation (and interest rates), labor shortages and workplace transformations, continued supply chain complications, and increasingly complex and controversial external reporting requirements are all just a few of the major obstacles facing organizations in the new year. With so many issues at the doorstep and […]

The goal of performance tuning in SQL is to minimize the execution time of the query and reduce the number of resources while processing the query. Whenever we run the query, performance depends on the amount of data and the complexity of the calculations we are working on. So, by reducing the no of calculations […]

2023 is almost here! New goals, new projects, and technological advancements are right around the corner. But before we look forward, we should reflect on the past year. There has been some great insight posted by my Perficient colleagues that can be great resources for managers, analysts, and administrators within the Enterprise Management Performance space. […]

Oracle has released over 25 new features this month for EDM (Enterprise Data Management). At the top of the list is a pre-built application type for Enterprise Profitability and Cost Management. The details for this new application type can be found here. But there are a number of other updates which warrant discussion as well. […]

A big benefit of Oracle EDM (Enterprise Data Management) is all of the pre-built application types contained within the solution. These application types greatly decrease the development time required by customers during EDM projects. Properties, validations, and exports are provided out-of-the-box with these application types. And starting with this month’s release, EDM now has a […]

Whatever the technology, everything revolves around three main components: Process, People, and Tools. And while “Tools” receive the majority of focus in any discussion in the technology arena, it’s the People that are the crucial component of successful organizations. We understand this here at Perficient and is a major reason why we continue to be […]