TRANSFORM A VIEW

vijay.barani · Post by **vijay.barani** » Tue Jun 09, 2009 12:39 am

Hi Friends,
Can we transform a view(NOT Table) from source database to target.Is there any way or chance to do so.Please help me.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 09, 2009 12:42 am

Yes (assuming that you have pertinent privileges).

If the view is in source, simply SELECT from it as you would from a table.

If the target is a view, then it must be an updatable view under the rules of the database, in addition to the privileges requirements.

bakshtheking · Post by **bakshtheking** » Tue Jun 09, 2009 2:50 am

Yes, you can...
Provided you have privileges to do that..
Specially for a view refresh, which is nothing but updating the table.

vijay.barani · Post by **vijay.barani** » Wed Jun 10, 2009 12:43 am

Thank you for the responce.
Hvae a nice day

vijay.barani · Post by **vijay.barani** » Wed Jun 10, 2009 12:46 am

But can we convert a view data of a database into a table of another database.Is there any chance.

ArndW · Post by **ArndW** » Wed Jun 10, 2009 12:52 am

That is not what was asked, you can read a view from one database and write to a table or updateable view in another database.

vijay.barani · Post by **vijay.barani** » Wed Jun 10, 2009 1:04 am

ArndW wrote:That is not what was asked, you can read a view from one database and write to a table or updateable view in another database. ...

Thank you.Yes this is another Question

Anyway when i was trying to load data from a view I am getting target also as a view.May I know what could be the issue please.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 10, 2009 2:07 am

DataStage does not control this. If the name of your target table is actually the name of a view, then it's a view you have. Chat with your DBA. If DataStage is generating DDL, it's always CREATE TABLE unless manually edited so you would never get a view in this case.

vijay.barani · Post by **vijay.barani** » Wed Jun 10, 2009 3:05 am

ray.wurlod wrote:DataStage does not control this. If the name of your target table is actually the name of a view, then it's a view you have. Chat with your DBA. If DataStage is generating DDL, it's always CREATE T ...

Thanks Ray.I got it now.

DSXchange

TRANSFORM A VIEW

TRANSFORM A VIEW

Re: TRANSFORM A VIEW