Posts Tagged ‘Informatica’

(What is it?) Mapping Architect for Visio is an Informatica power center client which is used to create mapping templates using Microsoft office Visio. (Why?) Mapping templates created using Visio work  as a sketch of PowerCenter mapping which offers reliability and improves efficiency in: Defining principles or rules that determines how specific procedures or methods can […]

I recently implemented an Informatica Lifecycle Management (ILM) project at a national auto financing company and I would like to share some details about what I learned about ILM and the benefits my client received.  ILM is a mature and robust data archiving tool used by many organizations to manage and archive large sets of […]

In my last blog, I presented a brief overview on Informatica Data Quality (IDQ) tools, the significance of Data Profiling and how to use the Analyst tool to profile data. In this second blog, I will introduce a few commonly used Informatica Developer tool Data Transformations. But, Why Data Transformations? Long story short, Data Quality […]

Whether your organization is currently evaluating cloud platforms and primarily storing data on-premises or you’ve made the journey to cloud and are adopting a hybrid model, accurate and timely access to data should be a focus. Regardless of where you are on your cloud journey, a flexible data management platform helps you to deliver what […]

Many of us have used the looping logic in programming languages or in others tool that we use. Looping logic is when you process each record continuously until it reaches its maximum limit. So, what’s new in looping logic? Let’s see here. In Informatica, it is quite problematic to loop a single record and there […]

Introduction In today’s fast paced world, Organizations have started using different types of software systems to compete and to be up to the speed of the world. This eventually increases the need for communication between different software systems and the same is growing by leaps and bounds. And with the Current data warehousing and data […]

Most of the enterprise data warehouse using Informatica PowerCenter to build the warehouse. After build the data warehouse and make it incremental load daily or several time per day. But data warehouse is not real time, it also has some gap between the source database and Target database. How can we make Data Warehouse Real […]

I recently attended the annual Tableau user conference in Austin, TX. They had record attendance this year with over 13,000 attendees. This highlights Tableau’s popularity and its reception in the marketplace. The big news was the keynote, which reviewed Tableau’s Three-Year Roadmap. Highlights included: A new data engine for faster analysis Project Maestro: A self-service […]

What is Hybrid SCD? Slowly Changing Dimension (SCD) Type 6 is also called as “Hybrid SCD” that combines three fundamental SCD techniques. Type 6 can be used when you want to maintain complete history and would also like to have an easy way to manage current version. The point of “type 6” or “Hybrid” processing […]

A couple of years ago, I read several articles detailing the challenges of Big Data and the confusion around implementation.  The message was as follows: Everyone talks about it, nobody really knows how to do it, everyone thinks everyone else is doing it, so everyone claims they are doing it. Since then, technology and Big […]

One of the biggest advantages of Salesforce as a CRM is the rapid growth of the platform itself. Customers have benefited immensely from Salesforce’s aggressive “growth first” strategy as the company seeks to help brands embed Salesforce more deeply in their businesses. From the Steelbrick and Demandware acquisition, adding CPQ and commerce capabilities to its product arsenal, to the […]

Adoption of cloud computing and SaaS applications continues to increase as advances in technology address concerns with security, privacy and customization limitations. The global SaaS market is projected to grow from $49B in 2015 to $67B in 2018, attaining a CAGR of 8.14% (Roundup of Cloud Computing Forecasts and Market Estimates, Forbes, Sept 27, 2015) […]