Skip navigation
Contact Us
1845 Views 14 Replies Latest reply: Dec 6, 2012 5:51 PM by Felix Ho RSS
Currently Being Moderated

Dec 3, 2012 1:21 AM

Target conflict

Source : Subscribers

Target1 : T_Subscribers   (Location1)

Target2: T_Subscribers   (Location2)

Assume I have three ODBC connections for Souce,two targets . I need to load the data from Subscribers(Source) to two Targets..

Please advise how to get those tables in my Target designer.. They are having same name but they are different dbs..

 

Thanks

  • Felix Ho Expert 342 posts since
    Aug 23, 2011
    Currently Being Moderated
    Dec 3, 2012 1:57 AM (in response to Santosh Kumar)
    Target conflict

    Hi,

     

    You don't need any customization on mapping level.

     

    In workflow manager, create 3 relational connections.

    1.) Source ODBC

    2.) Target 1 with target 1 ODBC connection string

    3.) Target 2 with target 2 ODBC connection string

     

    In session configuration,

    Set target 1 with relation connection  1 and target 2 with relation connection 2.

     

    Regards,

    Felix

  • sasi ramesh Master 1,110 posts since
    Oct 2, 2010
    Currently Being Moderated
    Dec 3, 2012 1:58 AM (in response to Santosh Kumar)
    Target conflict

    Hi Santosh,

     

    Import the target table and rename the table.In the session level ,we have option to provide the table name.Declare a variable and pass the value as subscribers for the variable.

     

    Use the variable in the session properies for the renamed target.

     

    Regards

    Sasiramesh

    • Sri 1236 Apprentice 265 posts since
      Mar 21, 2011
      Currently Being Moderated
      Dec 3, 2012 8:02 AM (in response to sasi ramesh)
      Target conflict

      Hi,

       

      Create two relational connections each pointing to different database. When importing tables into pwercenter, rename them to be unique. Now at the session level, just mention the target table name in the format   dbname.dbo.tablebname.

       

      I hope this will be useful along with suggestions from Sasi and Felix.

       

       

      Thanks.

    • PURUSHOTTAM KUMAR Newbie 10 posts since
      Dec 3, 2012
      Currently Being Moderated
      Dec 3, 2012 9:08 AM (in response to sasi ramesh)
      Target conflict

      Hi sasi sir,

       

      Can we create more than one repositiory for one node.. plz sir help me. i need ans of this.

       

      Regard

      Purushottam

      • Felix Ho Expert 342 posts since
        Aug 23, 2011
        Currently Being Moderated
        Dec 3, 2012 5:59 PM (in response to PURUSHOTTAM KUMAR)
        Target conflict

        Yes, you can create multiple repository service

        (REP-SVC) and integration service for one node

         

        One repository service need one schema (If you use Oracle) as repository.

         

        In general, you can have multiple REP-SVC to work with many repository in one node

        • PURUSHOTTAM KUMAR Newbie 10 posts since
          Dec 3, 2012
          Currently Being Moderated
          Dec 3, 2012 8:17 PM (in response to Felix Ho)
          Target conflict

          sir, i am using oracle database along with XE String. but while creating another repostiroy it's showing error that you cannot create.

          i have created infa8_rep_srvc repostiroy in xe string. but i want create another for devlopement repo

          so can you tell me in brief. what should be name of repositroy..

          • Felix Ho Expert 342 posts since
            Aug 23, 2011
            Currently Being Moderated
            Dec 3, 2012 8:49 PM (in response to PURUSHOTTAM KUMAR)
            Target conflict

            One connection string of your OS pointing to one unique schema in oracle.

            Let's say you have Schema REP_A and REP_B in oracle.

             

            One PowerCenter repository service need one unique schema, two repository service cannot point to the same schema. So, you create

            1. REP_SVC_A connect to connection string of REP_A (1st repository created)

            2. REP_SVC_B try to connect to connection string of REP_A (it doesn't work)

             

            What you need is to build a new one and connect to a new connection string

            3. REP_SVC_B try to connect to connection string of REP_B (2nd repository should be created)

            • PURUSHOTTAM KUMAR Newbie 10 posts since
              Dec 3, 2012
              Currently Being Moderated
              Dec 4, 2012 11:42 AM (in response to Felix Ho)
              Target conflict

              yeah you are right Felix.i would like to tell lot of thanks to you for gave me effort but problem is that i am using oracle 10g EXPRESS EDTION which having XE connection string.so when i create new repository this error is showing:

               

              The Repository Service was created, but the service could  not be enabled. You must enable the service to create the content. The following  error occurred while attempting to create the content. Error - [PCSF_10342]  Exception occurred: [Unable to start service [REP_SVC_A] on any node specified  for the service.].

            • PURUSHOTTAM KUMAR Newbie 10 posts since
              Dec 3, 2012
              Currently Being Moderated
              Dec 6, 2012 7:26 AM (in response to Felix Ho)
              Target conflict

              but string are predefined so we can not change that. when i am giving new name of string as u said that REP_A it can't not be.it shows error.

              • Felix Ho Expert 342 posts since
                Aug 23, 2011
                Currently Being Moderated
                Dec 6, 2012 5:51 PM (in response to PURUSHOTTAM KUMAR)
                Target conflict

                For my experience with Oracle,

                you should have a TNS file to store connection string of your connection.

                 

                Under the TNS file, you can create multiple connection string for multiple schema in the same SID.

                 

                So, PowerCenter need two different TNS connection string for two repository service.

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points