Joining two relational tables in Informatica without affecting performance

Asked By 0 points N/A Posted on -
qa-featured

Hello Everyone,

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?

SHARE
Answered By 0 points N/A #160759

Joining two relational tables in Informatica without affecting performance

qa-featured

Hi,

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.

http://www.devshed.com/c/a/MySQL/MySQL-Table-Joins/

Some necessary changes may need to adjust the data and syntax.

Login/Register to Answer

Related Questions