Answered Questions

  • how is the union transformation active transformation?

    Narendra

    • Sep 10th, 2011

    Union will give duplicate records also. Main reason is it is derived from custom transformation when union used with custom transformation at that time it works as active transformation. if any transformation have active functionality definitely that transformation is active.

    Thanks
    @Nandu

    mani

    • Sep 8th, 2011

    Union returns the distinct values when you merge the result set from 2 different tables.so duplicates are not allowed, so it is active transformation