Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Joins

Status
Not open for further replies.
taruna1

taruna1

MIS
May 12, 2004
12
0
0
US
have 2 Dimension tables, one view and one fact table. The dimension tables are fund and task.
Earlier the view table was joined to task and fund table.
View.Fundl = Fund.Fundl
View.Program = Task.Taskl

I am trying to change these joins to go through the fact table and still get the same result. I have modified these joins in the following manner.
Fact.Fundl = Fund.Fundl
Fact.Taskl = Task.Taskl
Fact.Fundl = View.Fundl
Fact.Taskl = View.Program.

Can anyone tell me if these joins will lead to the same result. If no, what would be the best way to get the same result if we have to go through the fact table.

Thanks
 
Status
Not open for further replies.

Similar threads

vaisag
  • Locked
  • Helpful tip
Joins in Impromptu
Replies
3
Views
22
vaisag
vaisag

Part and Inventory Search

Sponsor

Back
Top