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.
|1||All about Informatica Lookup||Basic|
|2||Aggregation with out Informatica Aggregator||Intermediate|
|3||Implementing Informatica Persistent Cache||Intermediate|
|4||The benefit and disadvantage of Informatica Persistent Cache Lookup||Advanced|
|5||Informatica Dynamic Lookup Cache||Intermediate|
|6||What is Active Lookup Transformation||Basic|
|7||Working with Informatica Flatfiles||Basic|
|8||Loading Flatfiles delimited by comma and double quotes||Intermediate|
|9||Informatica Excel Source||Basic|
|10||Informatica Reject File - How to Identify rejection reason||Basic|
|11||Implementing Informatica Incremental Aggregation||Intermediate|
|12||Using Informatica Stored Procedure Transformation||Basic|
|13||When to use Informatica Stored Procedure Transformation||Basic|
|14||Using Informatica Normalizer Transformation||Basic|
|15||Informatica Java Transformation||Basic|
|16||Calling C executable from Java Transform||Basic|
|17||Stop Hardcoding- Follow Parameterization Technique||Intermediate|
|18||CDC Implementation using Informatica Variable||Intermediate|
|19||CDC Implementation using Flatfile||Intermediate|
|20||Implementing SCD2 in Informatica Using ORA_HASH at Source||Intermediate|
|21||Comparing Performance of SORT operation (Order By) in Informatica and Oracle||Advanced|
|22||Informatica Join Vs Database Join||Advanced|
|23||Informatica Tuning - Step by Step Approach||Basic|
|24||Informatica Performance Tuning - Complete Guide||Intermediate|
|25||How to Tune Performance of Informatica Lookup Transformation||Advanced|
|26||How to Tune Performance of Informatica Joiner Transformation||Advanced|
|27||How to Tune Performance of Informatica Aggregator Transformation||Advanced|
|28||Implementing Informatica Partitions||Intermediate|
|29||Pushdown Optimization In Informatica||Intermediate|
|30||PowerCenter SOA Components||Basic|
|31||Informatica Metadata Tables - Overview and Tutorial||Basic|
|32||How to get Informatica Repository Information from Metadata||Basic|
|33||How to get Folders and Mapping names from Informatica Metadata Query||Basic|
|34||Useful Informatica Metadata Repository Queries||Basic|
|35||APEAR - A tool for automating Informatica Performance Tuning||Advanced|
|36||Best Informatica Interview Questions & Answers||Basic|
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
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.
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.