how to update schema of source and target tables in data flow

[Former Member]

Hi,

I am a newbee to data integrator. I am finding hard to update the source and target table schema in the data flow. when I right click on the tables, i see the options grayed out.

Help is much much appreciated!

-Jive

[Former Member]

you can't update the schema name/owner name of source of target from Dataflow, you can change the schema/owner of a table from the datastore

select the table in the datastore and use rename owner to change the schema/owner name

instead of using rename the other option is to define a Alias at the datastore level , read the technical manual for more detaild on Alias in the datastore

[dennis_scoville4]

You update the schema of your source and target tables in the Query transform. A Query transform defines what is being extracted (left panel) and what it's being loaded (right panel). Typically, the source table is an import and you wouldn't want to change the schema for it. The target schema can be changed to whatever you want it to look like, if it's a new table. If the table alreasdy exists in your database, them import it and when you connect the Query transform to it, the transform will assume the schema from the table.