Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting a Mapping Diagram from SQL Query

Suddhasatwa_BhaumikDec 4 2013 — edited Dec 4 2013

Hi,

I have 2 schemas: SOURCE and TARGET.

A previous developer had written an SQL Query to transform and load data from 3 tables from SOURCE schema into 1 table in the TARGET schema. It is working fine by use of the grants and synonyms that I have created.

My query is: Now I would like to convert this SQL query or transformation into a diagram. The diagram would show the columns of the source tables and the transformations which are then loaded into the target table.

Kindly advice which tool or software I can use for this? Or, should I go with the manual approach?

Regards,

Suddhasatwa

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 1 2014

Added on Dec 4 2013

#data, #general-database-discussions, #mapping, #sql

3 comments

718 views