• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » could not get schema of any table + how could i update the right colum

#1 2009-07-13 10:55:31

v.botz
Guest

could not get schema of any table + how could i update the right colum

HI,

i have 2 problems which belong together (i think)

1.   if i connect to a table (postgre or oracle) i could not get a schema from any table
      - no columns are given - i have do rebuild the stucture by hand...
      > sucks, what could i do ??

2. i would like to update only 2 columns of a table
    - tos uses always the first 2 columns, although i defined the 3rd and 4th column by tMap
     > so the wrong columns are updated....

what could i do ??

thanks v.botz

#2 2009-07-13 11:02:11

v.botz
Guest

Re: could not get schema of any table + how could i update the right colum

forgot something,

if i would like to use 'guess schema' on an input table, i got:

Connect to DB error, or some errors in SQL query string, or 'Guess Schema' not compatible with current SQL query string.

i would like to transfer a table from postgre 8.3 to oracle 9i..

greetings

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » could not get schema of any table + how could i update the right colum

Board footer

Powered by FluxBB