Submitted Questions

  • what are the transformations that restrict the partitioning of sessions?

    *Advanced External procedure transformation and External procedure transformation: This Transformation contains a check box on the properties tab to allow partitioning.*Aggregator Transformation: If you use sorted ports you cannot partition the associated source*Joiner Transformation: you can not partition the master source for a joiner transformation*Normalizer Transformation *XML targets.

    srinivas vadlakonda

    • Oct 11th, 2006

    Advanced External procedure transformation and External procedure transformation: This Transformation contains a check box on the properties tab to allow partitioning.Aggregator Transformation: If you...

    Manasa

    • Sep 7th, 2006

    1)source defination
    2)Sequence Generator
    3)Unconnected Transformation
    4)Xml Target defination

  • What are Data driven Sessions?

    The informatica server follows instructions coded into update strategy transformations with in the session mapping to determine how to flag records for insert,update,delete or reject. If you do not choose data driven optionn setting, the informatica server ignores all update strategy transformations in the mapping

    fazal

    • Sep 7th, 2006

    Once you load the data in your DW,you can update the new data with the following options in your session properties:-1.update 2.insert2.delete and datadriven, and all these options are present in your...