AEM/CQ5

when new AEM project was created and deployed to server but was not able

to find the created OSGI components in/system/console/components or

in manifest.mf or in bundle.

Solution:

Joiner Transformation -

Always prefer to perform joins in the database if possible, as database joins are faster than joins created in Informatica joiner transformation.
Sort the data before joining if possible, as it decreases the disk I/O performed during joining.
Make the table with less no of rows as master table.

Lookup Transformation –

Create an index for the column in a lookup table which is used in lookup condition. Since the lookup table will be queried for looking up the matching data, adding an index would increase the performance.
If possible, instead of using lookup transformation use join in the database. As database joins are faster, performance will be increased.
Delete unnecessary columns from the lookup table and keep only the required columns. This will bring down the overhead of fetching the extra columns from the database.

Filter Transformation –

Use filter transformation as early as possible inside the mapping. If the unwanted data can be discarded early in the mapping, it would increase the throughput.'
Use source qualifier to filter the data. You can also use source qualifier SQL override to filter the records, instead of using filter transformation.

Aggregator Transformation

Filter the data before aggregating it. If you are using filter transformation in the mapping, then filter the data before using aggregator as it will reduce the unnecessary aggregation operation.
Limit the no of ports used in the aggregator transformation. This will reduce the volume of data that aggregator transformation stores inside the cache.

Source Qualifier Transformation

Bring only the required columns from the source. Most of the times not all the columns of the source table are required, so bring only the required fields by deleting the unnecessary columns.
Avoid using order by clause inside the source qualifier SQL override. The order by clause requires additional processing and performance can be increased by avoiding it.

Information is a powerful ETL tool for Data integration for small as well as big market business.

To download and install Informatica, you must visit the link given here.

NOTE: Informatica has recently stopped distribution of PowerCenter. You can register for 30 Day trial of Informatica Cloud here

PowerCenter Express ETL

PowerCenter Express is an Informatica’ s market-leading data integration (ETL Tool) and in-line data profiling right-sized for smaller projects.

How to register for Informatica Cloud PowerExpress

Step 1) Open Link and click on FREE 30-DAY TRIAL

Step 2) Fill in the requested details and Click on Start Up 30 Days free trail

Step 3) You will get a confirmation page as below. Open your Email account and click the confirmation link.

Step 4) On clicking the confirmation URL, you are asked to set your Password and One Security Question. Click OK once you enter the data.

Step 5) You are now in Informatica Cloud which you can use for further exercises.

Informatica Versions History

With the new cloud version of Powercenter all the above versions have become obsolete.