2 Replies Latest reply: Jan 17, 2013 9:56 AM by 801667 RSS

    Problem with ODI Lookup

    801667
      I have two a table on source(Netezza DB) S1and two tables on target(SQL Server DB) T1 and T2 with structure as below

      S1
      ---
      Id
      Value

      T1
      ----
      Id


      T2
      ----
      Value

      My requirement is that if s1.Id=T1.Id then i have to map s1.value to T2.value.

      When I tried to use lookup feature, it is not allowing to lookup between two different connections.
      If i try to use a simple join, by dragging and dropping S1 and T1 on to source data store in the interface mapping section, The interface is failing in the runtime with below error.

      8000 : UNDEFINED : Unknown Types value.
      Unknown Types value.
           at org.netezza.jdbc1.AbstractJdbc1Statement.setObject(Unknown Source)
           at org.netezza.jdbc1.AbstractJdbc1Statement.setObject(Unknown Source)

      Let me know if we can achieve it by any other method.and the set of LKM and IKM suitable for this.

      Thanks,
      Naveen Kumar T.