Regarding exporting datamodel

sveeramani · Post by **sveeramani** » Mon Jan 22, 2007 9:39 pm

This is not ETL task, for the long term maintenance

DSguru2B · Post by **DSguru2B** » Mon Jan 22, 2007 10:42 pm

sveeramani wrote:This is not ETL task, for the long term maintenance

I say this is not an ETL task regardless.

kduke · Post by **kduke** » Mon Jan 22, 2007 11:06 pm

Who cares. If you have need then go for it. It is fun making DataStage do something it was not designed to do.

narasimha · Post by **narasimha** » Mon Jan 22, 2007 11:24 pm

I have been in some companies, who have bought Datastage and don't know why they did. They want it to do everything.
They used Datastage mostly as a scheduling tool and to run non-datastage jobs wrapped into datastage jobs to run in sequence

I_Server_Whale · Post by **I_Server_Whale** » Tue Jan 23, 2007 12:29 pm

narasimha wrote:I have been in some companies, who have bought Datastage and don't know why they did. They used Datastage mostly as a scheduling tool

That's ridiculous.

chulett · Post by **chulett** » Tue Jan 23, 2007 12:31 pm

No more ridiculous than DataStage jobs that just run Stored Procedures.

DSguru2B · Post by **DSguru2B** » Tue Jan 23, 2007 12:43 pm

chulett wrote:No more ridiculous than DataStage jobs that just run Stored Procedures.

You mean to say 200+ grand for just doing a simple command line exec stp

I_Server_Whale · Post by **I_Server_Whale** » Tue Jan 23, 2007 12:45 pm

DSguru2B wrote:
chulett wrote:No more ridiculous than DataStage jobs that just run Stored Procedures.
You mean to say 200+ grand for just doing a simple command line exec stp

And that's ridiculous to the power of ridiculous.

vijaykumar · Post by **vijaykumar** » Tue Jan 23, 2007 1:58 pm

Hi Gurus,
Sorry for posting here, but iam expecting help from you Gurus.
I connect the physical datamodel to oracle through ERWIN. I want to generate schema of my datamodel into oracle.

I created a subject area, later on clicked on forward engineer/schema generation in tools tab of ERWIN.Later on choose the option set, and selected few options, clicked on Generate schema.

Its not generating any DDL statements.
its saying all commands must be de-limited[/b].
This is regarding ERWIN TOOL.
please help me as you people are more experienced.

cheers;
vijay

chulett · Post by **chulett** » Tue Jan 23, 2007 2:19 pm

Come on... you are expecting help from us, no matter the tool you are having issues with? Puh-leese. Seek help from the people you work with when you have questions like that.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 23, 2007 3:42 pm

Or from your friend, perhaps.

Visit DSXchange home page to learn its coverage. There should be no reason to expect help on ERwin, Zen, motorcyle maintenance, or any other topic from this site.

kduke · Post by **kduke** » Tue Jan 23, 2007 8:44 pm

I read that book. I liked it. Zen and the Art of Motorcycle Maintenance.

Ray you shock me.

DSguru2B · Post by **DSguru2B** » Tue Jan 23, 2007 9:41 pm

kduke wrote:Ray you shock me.

Your not alone Kim.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 23, 2007 10:14 pm

Twenty years later Robert Pirsig wrote his second book, called "Lola" if I remember correctly. Long time between books. Not nearly as good, in my opinion.

Why shocked? If you remember the sixties you weren't there?

DSguru2B · Post by **DSguru2B** » Wed Jan 24, 2007 7:38 am

ray.wurlod wrote: Why shocked? If you remember the sixties you weren't there?

Well I am shocked because of your diversity in knowledge and pass times. If i recall, you even play a sitar, right?
And no I was'nt there in the sixties

DSXchange

Regarding exporting datamodel

Ray Wurlod is correct.

Re: Ray Wurlod is correct.