Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Oct 12, 2010 at 11:43 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2010 at 04:41 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.