Oracle

Little boy pretending to be a pilot

4 Great Shortcuts for Oracle Cloud HCM Compensation

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

Istock 903569480 (5)

ETL & SQL : The Dynamic Data Duo

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

Abstract digital global map with data points

Basic Understanding of Full Load And Incremental Load In ETL (PART 1)

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

Road Journey

HFM to FCC – Looking Back What Would You Change? Part 4

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

Azure Databricks

Key Features Recently Made Available in Oracle Enterprise Data Management

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

Group of web developers working in an office.

Feature of Snowflake: Zero Copy Cloning

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

Perficient’s Own Journey to Oracle ERP and HCM Cloud

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

Coding On Laptop 1200x.progressive

How to create zip file which contains single text file with a fixed threshold in SSIS.

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

Istock 935964092

Implementation of XML Extract in SSIS

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

Group of web developers working in an office.

HOW TO IMPLEMENT BASIC ETL TEST SCENARIOS (PART 1)

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

tiethnic colleagues sitting at desk looking at laptop computer in office. stock photo

How to Convert Blank Values to Null in Flat File Source in SSIS Package

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

Navigating from EBS Journal Lines to Originating Transactions – Part II

In our last post we discussed the linkages between Journal Entries and the source transactions in Accounts Payable, Accounts Receivable, and Fixed Assets.  This post continues the discussion with the linkages for the Purchasing, Project Accounting, and Cost Management applications. As noted in the prior posting, since most organizations employ summary posting of Journal entries, […]

Load More