Tuesday 9 October 2012

Source qualifier versus Joiner Transformation

Source qualifier

  • Use one Source Qualifier transformation to join data from multiple relational tables. These tables must be accessible from the same instance or database server.
  • When a mapping uses related relational sources, you can join both sources in one Source Qualifier transformation. During the session, the source database performs the join before passing data to the Integration Service. This can Increase performance when source tables are indexed.

Joiner

  • Use the Joiner transformation for heterogeneous sources and to join flat files.
  • Use the Joiner transformation when you need to join the following types of sources:
  1. Join data from different source databases
  2. Join data from different flat file systems
  3. Join relational sources and flat files

4 comments:

  1. we have two oracle table in different server can we join these table to source qualifier transformation in informatica

    ReplyDelete
  2. No. tables must be accessible from same instance or DB.

    ReplyDelete
  3. No. tables must be from same database.

    ReplyDelete
  4. I have one Informix and other SQL server source can I join these tables using Source qualifier transformation

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...

ShareThis