2 Replies Latest reply on Aug 10, 2021 3:48 AM by user165569

    parameterize runtime properties

    Niaga Prima Seasoned Veteran

      hi all,

      we created a mapping to write data from hive to hive and set runtime properties in developer client to handle a small files,when we make a static mapping and declare runtime properties "flex.partitionspec2", a mapping is sucessfully running and can divided a small files into some file we declare.

       

      1. there is posible to set runtime properties "flex.partitionspec2" with dynamic parameterize in static mapping, where just runtime properties value is always change?

      2.  there is posible to set runtime properties "flex.partitionspec2" with dynamic parameterize in dynamic mapping?

       

       

      thanks

        • 1. Re: parameterize runtime properties
          PradeepKumar Active Member

          Hi

           

          I think it should work for both of the scenarios. Please generate the execution plan in 'Verbose Initialization' mode and search for the CLUMP keyword in it. The verbose init log should have the below

           

          1. the actual FlexPartitionSpec2 property and its value

          2. the CLUMP keyword next to the target object name

           

          If you could see the above then it should enforce them during mapping execution. If the above (2) is missing in the log, try to change the optimizer level to NORMAL and regenerate the execution plan.

           

          Execution plan gets stored in $INFA_HOME/..../disLogs/ms.

           

          Regards

          Pradeep

          • 2. Re: parameterize runtime properties
            user165569 Guru

            Hi Niaga Prima,

             

            The mapping runtime property FlexPartitionSpec2 can be used with static as well as dynamic mappings. And the same could be parameterized as well.

             

            Thanks,
            Ninju

            Infomatica Support