Answered Questions

  • where does the records goes which does not satisfy condition in filter transformation?

    Sujaya

    • Sep 3rd, 2007

    There is no default group in Filter Transformation. The records which does not satisfy filter condition are discarded and not written to reject file or session log file

    babu

    • Jul 11th, 2007

    The rows which are not satisfing the filter transformation are discarded. It does not appear in the session logfile or reject files.

  • What r the diffrence between joiner transformation and source qualifier transformation?

    U can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation. U need matching keys to join two relational sources in source qualifier transformation.Where as u doesn’t need matching keys to join two sources. Two relational sources should come from same datasource in sourcequalifier.U can join relatinal sources which r coming from diffrent...

    divakar

    • Nov 5th, 2007

    source qualifier is used for reading the data from the database where as joiner transformation is used for joining two data tables.source qualifier can also be used to join two tables but the conditio...

    pkonakalla

    • May 23rd, 2007

    hi, as per my knowledge, you need matching keys to join two relational sources both in Source qualifier as well as in Joiner transformation. But the difference is that in Source qualifier, both the keys must have primary key - foreign key relation, Whereas in Joiner transformation its not needed.