Fully Qualified Table Name

srinagesh · Post by **srinagesh** » Mon Nov 28, 2005 11:16 am

Hi !

One of the developers has imported table definitions with Fully Qualified table definitions checked on..

The tables are now defined as "wms_dw.factTable" (for eg)..

I tried to change the Fully Qualified name thru the Datastage Manager, but that is Greyed out.

Is there a way of removing the schema name from the Table definition?

kcbland · Post by **kcbland** » Mon Nov 28, 2005 5:40 pm

From DS Manager focus on the name of the definition, right click the name of the table definition and rename.

srinagesh · Post by **srinagesh** » Tue Nov 29, 2005 8:20 am

Hi !

I tried doing it .. but I dont get option to rename.

ArndW · Post by **ArndW** » Tue Nov 29, 2005 8:25 am

did you try it in the right pane in the manager ? It's always worked for me.

chulett · Post by **chulett** » Tue Nov 29, 2005 8:30 am

...as long as you don't have one of the 'extended' views on, I believe that may disable it.

ArndW · Post by **ArndW** » Tue Nov 29, 2005 8:43 am

Craig - I'm sure that's going to be the solution; I had the same problem a couple of weeks ago and couldn't figure out why certain things weren't working as expected.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 30, 2005 1:00 am

Why not just re-import without qualification enabled?

srinagesh · Post by **srinagesh** » Wed Nov 30, 2005 3:18 am

Thats exactly what I did.
:D

Thanks Guys

-Nagesh