hi
i used SQL connection where i have data in Dimension Table but
i want load the common fields in Fact table from all Dimension tables
now problem is i am facing is that when i used one connection where all
data in dimension table and i want to fetch in fact table. Database is same
for Fact and Dimension table
so i have used other connection with same database but its shows no
transfomation between to connection?
and if i used staging its show me no data in fact table?
so anybody help me

--
Message posted via http://www.sqlmonster.com