Learning Path for ETL Design Informatica

New to this topic? Not sure where to start? For your convenience, we have created the below learning path where articles are organised in the order of their relevance and complexity. Start from the beginning and read one by one to master the subject.

OrderTopicLevelCBIP
1All about Informatica LookupBasic
2Aggregation with out Informatica AggregatorIntermediate
3Implementing Informatica Persistent CacheIntermediate
4The benefit and disadvantage of Informatica Persistent Cache LookupAdvanced
5Informatica Dynamic Lookup CacheIntermediate
6What is Active Lookup TransformationBasic
7Working with Informatica FlatfilesBasic
8Loading Flatfiles delimited by comma and double quotesIntermediate
9Informatica Excel SourceBasic
10Informatica Reject File - How to Identify rejection reasonBasic
11Implementing Informatica Incremental AggregationIntermediate
12Using Informatica Stored Procedure TransformationBasic
13When to use Informatica Stored Procedure TransformationBasic
14Using Informatica Normalizer TransformationBasic
15Informatica Java TransformationBasic
16Calling C executable from Java TransformBasic
17Stop Hardcoding- Follow Parameterization TechniqueIntermediate
18CDC Implementation using Informatica VariableIntermediate
19CDC Implementation using FlatfileIntermediate
20Implementing SCD2 in Informatica Using ORA_HASH at SourceIntermediate
21Comparing Performance of SORT operation (Order By) in Informatica and OracleAdvanced
22Informatica Join Vs Database JoinAdvanced
23Informatica Tuning - Step by Step ApproachBasic
24Informatica Performance Tuning - Complete GuideIntermediate
25How to Tune Performance of Informatica Lookup TransformationAdvanced
26How to Tune Performance of Informatica Joiner TransformationAdvanced
27How to Tune Performance of Informatica Aggregator TransformationAdvanced
28Implementing Informatica PartitionsIntermediate
29Pushdown Optimization In InformaticaIntermediate
30PowerCenter SOA ComponentsBasic
31Informatica Metadata Tables - Overview and TutorialBasic
32How to get Informatica Repository Information from MetadataBasic
33How to get Folders and Mapping names from Informatica Metadata QueryBasic
34Useful Informatica Metadata Repository QueriesBasic
35APEAR - A tool for automating Informatica Performance TuningAdvanced
36Best Informatica Interview Questions & AnswersBasic

In the previous article, we showed how surrogate keys can be generated without using Sequence Generator transformation. However, if Informatica partitioning is implemented for such cases, then since each partition pipeline will call the lookup simultaneously, we will end up generating duplicate sequence numbers. In this article, we will see how we may resolve this issue.

It is possible to generate sequential surrogate key in the target table without the use of an Informatica Sequence Generator transformation. Using this option, one can avoid any gap in the sequence numbers of the surrogate key.

Welcome to the finest collection of Informatica Interview Questions with standard answers that you can count on. Read and understand all the questions and their answers below and in the following pages to get a good grasp in Informatica. If you need any help, do not hesitate to post your questions in our Community Forum and our experts or other community members will answer your questions.

DWBIConcepts is launching APEAR – an Automated Performance Evaluation and Reporting tool for Informatica. As the name suggests, this tool will help you tune the performance of Informatica sessions fully automatically. Now don't waste your precious time any longer trying to figure out how to speed up your Informatica sessions.

Informatica metadata repository stores and maintains information about all the objects in Informatica. They contain details of connection information, users, folders, mappings, sources, targets etc. These information can serve many purposes while accessed through external SQL query.

We can use OPB_MAPPING and OPB_SUBJECT tables residing under informatica Repository to obtain information about all the mappings under each Informatica Folder. Following SQL query shows you how to do it.

Some metadata views can be very handy to get Informatica Repository Information. Know How.

Informatica PowerCentre stores all the information about mapping, session, transformation, workflow etc. in a set of database tables called metadata tables. While these tables are used internally by Informatica, one can get useful information by accessing it separately

PowerCenter has a Service-Oriented Architecture that provides the ability to scale services and share resources across multiple machines. Let us know more about the components and services associated with Powercenter.

Pushdown Optimization which is a new concept in Informatica PowerCentre, allows developers to balance data transformation load among servers. This article describes pushdown techniques.

Identification and elimination of performance bottlenecks will obviously optimize session performance. After tuning all the mapping bottlenecks, we can further optimize session performance by increasing the number of pipeline partitions in the session. Adding partitions can improve performance by utilizing more of the system hardware while processing the session.

Similar to what we discussed regarding the Performance Tuning of Joiner Transformation, the basic rule for tuning aggregator is to avoid aggregator transformation altogether unless...

Joiner transformation allows you to join two heterogeneous sources in the Informatica mapping. You can use this transformation to perform INNER and OUTER joins between two input streams.

For performance reasons, I recommend you ONLY use JOINER transformation if any of the following condition is true –

To me, look-up is the single most important (and difficult) transformation that we need to consider while tuning performance of Informatica jobs. The choice and use of correct type of Look-Up can dramatically vary the session performance in Informatica. So let’s delve deeper into this.

This article is a comprehensive guide to the techniques and methodologies available for tuning the performance of Informatica PowerCentre ETL tool. It's a one stop performance tuning manual for Informatica.

This is the first of the number of articles on the series of Data Warehouse Application performance tuning scheduled to come every week. This one is on Informatica performance tuning.

In this yet another "DWBI Concepts' Original article", we test the performance of Informatica PowerCentre 8.5 Joiner transformation versus Oracle 10g database join. This article gives a crucial insight to application developer in order to take informed decision regarding performance tuning.

In this "DWBI Concepts' Original article", we put Oracle database and Informatica PowerCentre to lock horns to prove which one of them handles data SORTing operation faster. This article gives a crucial insight to application developer in order to take informed decision regarding performance tuning.

In this article we shall see how we can implement SCD type2 in Informatica using ORA_HASH, which is an ORACLE function that computes hash value for a given expression. We can use this feature to find the existence of any change in any of the SCD column.

This article shows how to use a flatfile to implement Change data Capture. Suppose we want to maintain the last extraction date in a flatfile, based on that value we want to capture the changed data of our business table.


Have a question on this subject?

Ask questions to our expert community members and clear your doubts. Asking question or engaging in technical discussion is both easy and rewarding.

Are you on Twitter?

Start following us. This way we will always keep you updated with what's happening in Data Analytics community. We won't spam you. Promise.