Regarding exporting datamodel
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
Regarding exporting datamodel
Hi Gurus,
My friend has developed a datamodel, i have created a schema in oracle, i want to export the datamodel into my schema.Can anyone help me out.
cheers;
vijay
My friend has developed a datamodel, i have created a schema in oracle, i want to export the datamodel into my schema.Can anyone help me out.
cheers;
vijay
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Re: Regarding exporting datamodel
Was the datamodel created using any tool, for ex: ERwin, etc? How was the datamodel created?vijaykumar wrote:My friend has developed a datamodel,
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Me too! And like Narasimha suggested, why not use Erwin to create the PDM.kumar_s wrote:So I assume its LDM to PDM (Logical Data model to Physical Data Model).
Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
Hi Gurus,
I mean to say ,for eg: scott is the default schema name in oracle.
instead of working out with that schema, iam creating new schema by sql command
create user username identified by password.
grand dba priviledges.
Actually my requirement is:I was given a datamodel . Now what i want is that i want to fire SQL queries into that datamodel so as to validate all the relationships(entity relationships, primary key and foreign key relationships described are valid).
How can i do that.
cheers;
vijay
I mean to say ,for eg: scott is the default schema name in oracle.
instead of working out with that schema, iam creating new schema by sql command
create user username identified by password.
grand dba priviledges.
Actually my requirement is:I was given a datamodel . Now what i want is that i want to fire SQL queries into that datamodel so as to validate all the relationships(entity relationships, primary key and foreign key relationships described are valid).
How can i do that.
cheers;
vijay
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
The optimized approach would be...
wrap the SQLs in a SQL file. Call that SQL through a shell script. Call that script through an Execute command Activity stage in Datastage. Call that JobControl using a BASIC Routine.
And finally Schedule it.![Wink :wink:](./images/smilies/icon_wink.gif)
wrap the SQLs in a SQL file. Call that SQL through a shell script. Call that script through an Execute command Activity stage in Datastage. Call that JobControl using a BASIC Routine.
And finally Schedule it.
![Wink :wink:](./images/smilies/icon_wink.gif)
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
As others have noted, this is not an ETL task, and therefore DataStage is not the correct tool.
Whatever tool you used to develop the logical model ought to have the capability to create a physical model, and to generate DDL from that. If not, find a tool that can, such as ERwin, ER/Studio, Rational, and so on.
Such tools integrate more closely with IBM Information Studio, as they share a common repository.
Whatever tool you used to develop the logical model ought to have the capability to create a physical model, and to generate DDL from that. If not, find a tool that can, such as ERwin, ER/Studio, Rational, and so on.
Such tools integrate more closely with IBM Information Studio, as they share a common repository.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.