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 […]
Technology Partners
The Corporate Athlete: Balancing A Technology Career in the Motherhood Space
The alarms sounds. It’s 5:00 am. The house is quiet. It’s here, my most productive and focused time of day. The smell of fresh brewed coffee fills the air as the sun begins to peek over the trees outside my office window. The stillness allowing for the clearest focus and strategic thinking to set up […]
Introduction to Matillion ETL
What is ETL and how it works? ETL stands for Extraction, Transformation, and Loading. It is the process in which data is extracted from different sources and transformed into proper format. Data management plays the important role as it improves the productivity, reduces error, strengthens operational efficiency, minimizes data loss, and improves security. There are […]
A Basic Introduction to Amazon Web Services (AWS) for IoT
Hello readers!!!! It’s time to get back to the Internet of Things (IoT). In the previous blog I had given an introduction to IoT and discussed about how AI empowers IoT. Please click the link below if you haven’t already gone through it. In this blog, I’ll discuss about the well-known cloud provider, Amazon Web […]
Unexpected MDX assumptions and error handling for subsets in TM1/Planning Analytics
I had a bug in a TM1 application recently that was very difficult to track down, and it was because I didn’t understand the different ways that TM1 might respond to vague or incorrect MDX expressions. MDX makes some unexpected assumptions. Take the following simplified example cube: Let’s say that I have an active form […]
How to become “AWS Certified Cloud Practitioner”
In a tech community, we all are aware of how the world is adopting, using and shifting some of the services to cloud as it offers great amount of flexibility, reliability, convenience, and cost cuttings. for example In the cloud, the services and servers (computing power) are on demand and you pay for only what […]
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 […]
AWS Elastic Load Balancing (ELB) And Its Types: A Brief Introduction
We’ll discuss AWS Elastic Load Balancing (ELB) in this blog. One of the most critical duties in just about any firm is Distributing Workloads among various Computing Resources. The service Amazon AWS Elastic Load Balancer was explicitly created for dispersing workloads. This blog’s AWS load balancer lesson will delve deep into AWS ELB. The following […]
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 […]
Data Flows in Azure Data Factory
Overview: Data flows are one of the features inside the Azure Data Factory which allows data engineers to develop data transformation logic in a graphical approach without writing code. The resulting data flows can then be executed as activities within Azure Data Factory pipelines that use scaled-out Spark clusters. Your data flows will run on […]
Historical Restatement in OneStream using very little code
In today’s modern business world, a company’s organization structure can change more frequently than anticipated through changes in ownership, acquisitions, divestitures and mergers. For those companies leveraging a robust CPM platform like OneStream, the organization’s structure is usually represented in the Entity dimension. This blog discusses a scenario where an entity changed owners and how […]
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 […]