6 Replies Latest reply: Aug 29, 2012 1:20 AM by Sai RSS

    Easy replacement of a source datastore

    user1459647
      Hi gurus,

      Is there an easy way to replace a source datastore by another one with the same structure in an interface ?
      Without having to re-do the join, filter and the mapping of target column.


      Thanks for your help.



      Regards
        • 1. Re: Easy replacement of a source datastore
          Sutirtha Roy
          1> Note down the source table alias name used in interface.
          2> Delete the source table from interface .
          All your join/filter/mapping will get invaild .
          3> Drag drop the new source table in interface canvas.
          4> change the table alias name to that of step 1

          other option

          use synonym insted of table/view etc.
          in such case you just need to drop the synonym and re-create it pointing to the new table/view etc

          Thanks,
          Sutirtha
          • 2. Re: Easy replacement of a source datastore
            user1459647
            Thank you for your quick and precise reply.


            Unfortunately, when I delete a source datastore, all the joins/filters involving this datastore disappear.
            And all the target mappings involving this datastore are set on "Target" instead of "Source" (not a big deal).


            Is there something to change in my ODI Studio parameters ?

            I'm using ODI 11.1.1.5 and Windows 7.
            • 3. Re: Easy replacement of a source datastore
              Sutirtha Roy
              user1459647  wrote:
              Thank you for your quick and precise reply.


              Unfortunately, when I delete a source datastore, all the joins/filters involving this datastore disappear.
              It will happen if your join condition/filter is specified only on 2 tables and 1 of them is getting deleted.
              And all the target mappings involving this datastore are set on "Target" instead of "Source" (not a big deal).
              You can chage the execution area
              Is there something to change in my ODI Studio parameters ?
              I do not think so
              I'm using ODI 11.1.1.5 and Windows 7.
              That should be fine .

              You can explore the SYNONYM option also :)
              • 4. Re: Easy replacement of a source datastore
                934476
                Isn't it possible to change it in the repository ?

                Edited by: Jerome on Aug 28, 2012 1:57 AM
                • 5. Re: Easy replacement of a source datastore
                  user1459647
                  Ok thank you for the information :).

                  I'll see with my colleagues if we gonna use the synonym option.
                  • 6. Re: Easy replacement of a source datastore
                    Sai
                    Hi All,

                    If I understand the requirement correctly, there is an another way of doing it. The idea I got is If the new datastore and the original datastore are having same structure then just define an ODI variable with the table name use this variable in the Resource Name of the datastore . Then put the variable and your Interface in the package and make sure before running the package the variable is loaded with correct table name which you required.

                    I guess this will meet your requirement , Please let me know if you have any challenges in implementing the above idea.

                    Regards,
                    Sai.