N/APosted on - 10/02/2012
My scenario is to join two relational tables without using Joiner Transformation since it affects the performance of power center to perform join query on all data [my source data is huge]. Is there any way i can do it in database or source level in the mapping?
Joining two relational tables in Informatica without affecting performance
If you do not want to use Joiner Transformation, you should take MySQL system for joining the data. It normally does not influence the data performance. By adding syntax this can be done.
Just have a look in the course of MySQL.
Some necessary changes may need to adjust the data and syntax.