agora Posted January 21, 2015 Report Share Posted January 21, 2015 paina chesina dekh... k thx Link to comment Share on other sites More sharing options...
sukha_purushudu Posted January 21, 2015 Report Share Posted January 21, 2015 data warehousing lo , do we load dimensions first or facts first ? , if so any reason , ee roju interview lo desi l**** asked this question Link to comment Share on other sites More sharing options...
loveindia Posted January 21, 2015 Report Share Posted January 21, 2015 data warehousing lo , do we load dimensions first or facts first ? , if so any reason , ee roju interview lo desi l**** asked this question answer neeku teliyaka potey aadni enduku man tidutunnav... we load dimensions first and then the facts as the measures are available on the dimensions.. If you have a new dimensionID and that primary key is not loaded in the dimension, and if you process the fact without it, the process will fail... I hope you got the answer... Link to comment Share on other sites More sharing options...
sukha_purushudu Posted January 21, 2015 Report Share Posted January 21, 2015 answer neeku teliyaka potey aadni enduku man tidutunnav... we load dimensions first and then the facts as the measures are available on the dimensions.. If you have a new dimensionID and that primary key is not loaded in the dimension, and if you process the fact without it, the process will fail... I hope you got the answer... Orrni , love india baiya i answered the same way ...i thought thats incorrect , aa desi gadu .... why only dimensions first not fact ani , malli answer iste sure pakka aa ani adigadu so was not confident... thanks dude... jai ballaya jai jai ballya Link to comment Share on other sites More sharing options...
loveindia Posted January 21, 2015 Report Share Posted January 21, 2015 Orrni , love india baiya i answered the same way ...i thought thats incorrect , aa desi gadu .... why only dimensions first not fact ani , malli answer iste sure pakka aa ani adigadu so was not confident... thanks dude... jai ballaya jai jai ballya Jai Balayya man... correct the spelling man... Link to comment Share on other sites More sharing options...
mtkr Posted January 21, 2015 Report Share Posted January 21, 2015 data warehousing lo , do we load dimensions first or facts first ? , if so any reason , ee roju interview lo desi l**** asked this question Fact tables holds Dimension tables primary keys as foreign keys in it... so first Dimension tabls nxt fact tables.... but dimension table can also act as fact tbl in other datamart... so appudu idi fact tbl avuthadi vere DM lo... so alaantappudu ee tbl(wch is fact tbl now n earlier it was dimension tbl) ni frst e load chesam... so aa interwr adi expect chesademo.... (lyk dimension tbl can also act as fact tbl to other DM) http://www.codeproject.com/Articles/652108/Create-First-Data-WareHouse Link to comment Share on other sites More sharing options...
agora Posted January 21, 2015 Report Share Posted January 21, 2015 Fact tables holds Dimension tables primary keys as foreign keys in it... so first Dimension tabls nxt fact tables.... but dimension table can also act as fact tbl in other datamart... so appudu idi fact tbl avuthadi vere DM lo... so alaantappudu ee tbl(wch is fact tbl now n earlier it was dimension tbl) ni frst e load chesam... so aa interwr adi expect chesademo.... (lyk dimension tbl can also act as fact tbl to other DM) http://www.codeproject.com/Articles/652108/Create-First-Data-WareHouse k Link to comment Share on other sites More sharing options...
loveindia Posted January 21, 2015 Report Share Posted January 21, 2015 Fact tables holds Dimension tables primary keys as foreign keys in it... so first Dimension tabls nxt fact tables.... but dimension table can also act as fact tbl in other datamart... so appudu idi fact tbl avuthadi vere DM lo... so alaantappudu ee tbl(wch is fact tbl now n earlier it was dimension tbl) ni frst e load chesam... so aa interwr adi expect chesademo.... (lyk dimension tbl can also act as fact tbl to other DM) http://www.codeproject.com/Articles/652108/Create-First-Data-WareHouse dat is snowflake schema man... Link to comment Share on other sites More sharing options...
agora Posted January 21, 2015 Report Share Posted January 21, 2015 dat is snowflake schema man... mari star schema :D Link to comment Share on other sites More sharing options...
mtkr Posted January 21, 2015 Report Share Posted January 21, 2015 dat is snowflake schema man... eadi!??? dim tbl as fact tbl aa!! Link to comment Share on other sites More sharing options...
loveindia Posted January 21, 2015 Report Share Posted January 21, 2015 eadi!??? dim tbl as fact tbl aa!! yes man... Link to comment Share on other sites More sharing options...
loveindia Posted January 21, 2015 Report Share Posted January 21, 2015 mari star schema :D star schema is straight forward representation of OLTP in a OLAP manner man, thats it... Link to comment Share on other sites More sharing options...
mtkr Posted January 22, 2015 Report Share Posted January 22, 2015 yes man... ante marii... adiii... akkada... intwr ea typ o adagaledhu kadaa aniiii!!!!! Link to comment Share on other sites More sharing options...
sukha_purushudu Posted January 23, 2015 Report Share Posted January 23, 2015 Jai Balayya man... correct the spelling man... Link to comment Share on other sites More sharing options...
sukha_purushudu Posted February 4, 2015 Report Share Posted February 4, 2015 yes man... SSIS Class start chesava ? Link to comment Share on other sites More sharing options...
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts