I am new to Toad Data Point and I am creating a database diagram to use as a template for the query builder. How do you create a table alias in the database diagram? I have dimension tables like date_dim and race_dim that I would like to join multiple copies of to the fact tables using table aliases but I can’t figure out how to do that in the database diagram. Thank you for your help.
TDP does not support aliases in ER diagram but when you send a diagram to Query Builder you will be able to set aliases for tables.
To do so select columns you’d like to include into the query and then set the aliases in property grid. It’s the last row in the property grid.
Regards
Aleksey
We have been able to create aliases in Query Builder and that will work for us.
Thank you,
Katherine Benson
IS Administrator
Hawaii Health Data Warehouse
Ph: (855) 946-5899, x13 (toll free)
Visit: www.hhdw.org
or www.HawaiiHealthMatters.org
From: Aleksey Bazhenov [mailto:bounce-AlekseyBazhenov@toadworld.com]
Sent: Tuesday, March 21, 2017 2:02 PM
To: toaddatapoint@toadworld.com
Subject: RE: [Toad Data Point - Discussion Forum] How do you create a table alias in the database diagram?
RE: How do you create a table alias in the database diagram?
Reply by Aleksey Bazhenov
TDP does not support aliases in ER diagram but when you send a diagram to Query Builder you will be able to set aliases for tables.
To do so select columns you’d like to include into the query and then set the aliases in property grid. It’s the last row in the property grid.
Regards
Aleksey
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad Data Point Forum notifications altogether.
Toad Data Point - Discussion Forum
Flag
this post as spam/abuse.