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

5 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
  5. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in IBM Cognos Transformer Design OLAP Models (v10.2.2) - SPVC (J2A82G-SPVC)
    , kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on in IBM Cognos Transformer Design OLAP Models (v10.2.2) - SPVC (J2A82G-SPVC). We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us:
    Name : Arunkumar U
    Email : arun@maxmunus.com
    Skype id: training_maxmunus
    Contact No.-+91-9738507310
    Company Website –http://www.maxmunus.com


    ReplyDelete

Related Posts Plugin for WordPress, Blogger...

ShareThis