Oracle

How do Oracle Cloud HCM workflow and approvals work? How do I configure that? How do I smoke test and then how the heck do I migrate these so that I don’t have to build them manually again? If you’ve ever asked yourself one of these questions, then hopefully this blog on Tips and Tricks […]

Finding a new shortcut, such as DIY home projects or driving to a familiar location, is always helpful.  Of course, it is nice to be more efficient at work; any tips can help improve your speed. Specifically, the Compensation module for Oracle Cloud HCM has many shortcuts to enhance the user experience.  Unfortunately, we continue […]

Data is the lifeline of any modern organization. At any point, every day, you work on molding data points into information to derive profits. Therefore, having the right building blocks is a crucial part of running a good business. This is where the dynamic duo of ETL and SQL comes into play. While you may […]

Full Load: Full Load in ETL is loading ALL the data from the source to the destination. A target table is truncated before loading everything from the source. That’s why this technique is also known as Destructive Load. In full load first we truncate the destination table and then we load all the data from source […]

Finance leaders from Cardtronics and Allegis Group with more than three years of combined experience using Oracle Financial Consolidation and Close joined Perficient and Oracle for a panel discussion regarding their cloud journey.  Richard Ng, Director, Financial Systems, Cardtronics, and John Oliphant, Financial Developer Lead Allegis Group, shared the stories of their organizations’ migration from […]

The most recent release of new features for Oracle Enterprise Data Management contain some great capabilities. Continue reading below to find out more!   Viewpoint Querying The ability to search for nodes within Oracle EDM has been greatly enhanced with the recent addition of Viewpoint Queries. Now, users can easily find nodes within a viewpoint […]

                                                                      Feature of Snowflake: Zero-Copy Cloning Zero Copy Cloning in Snowflake: Snowflakes have some advanced feature like Time Travel, zero-copy cloning […]

Be intentional. Be simple and intuitive. Focus on the future. Use a global mindset. These are the guiding principles in how Perficient’s Oracle ERP and HCM practice is transforming our own back office from Oracle E-Business Suite to Oracle Cloud. In a recent webinar, Perficient’s Vice President of People, Andrea Lampert, Chief Financial Officer, Paul Martin, […]

What is SSIS? SQL Server Integration Service (SSIS) is a component of the Microsoft SQL Server database software that can be used to execute a wide range of data migration tasks. The SSIS ETL tool Extracts data from different sources and transforms that data according to user requirements. And then loads data into various destinations. […]

SQL Server Integration Service (SSIS) : SSIS is a component of the Microsoft SQL Server database software that can be used to execute a wide range of data migration tasks. SSIS is a fast & flexible data warehousing tool used for data extraction, loading and transformation like cleaning, aggregating, merging data, etc. It makes it […]

In this blog, we will see what the basic test scenarios for ETL testing are. However, before we go to the ETL test scenarios, let me first tell you what ETL is and how it works, along with the process involved with it. WHAT IS ETL? ETL stands for Extract-Transform-Load, and it is a process […]

SQL Server Integration Services(SSIS): SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading. In […]