sukha_purushudu Posted January 21, 2015 Report 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
loveindia Posted January 21, 2015 Report 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...
sukha_purushudu Posted January 21, 2015 Report 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
loveindia Posted January 21, 2015 Report 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...
mtkr Posted January 21, 2015 Report 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
agora Posted January 21, 2015 Report 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
loveindia Posted January 21, 2015 Report 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...
agora Posted January 21, 2015 Report Posted January 21, 2015 dat is snowflake schema man... mari star schema :D
mtkr Posted January 21, 2015 Report Posted January 21, 2015 dat is snowflake schema man... eadi!??? dim tbl as fact tbl aa!!
loveindia Posted January 21, 2015 Report Posted January 21, 2015 eadi!??? dim tbl as fact tbl aa!! yes man...
loveindia Posted January 21, 2015 Report Posted January 21, 2015 mari star schema :D star schema is straight forward representation of OLTP in a OLAP manner man, thats it...
mtkr Posted January 22, 2015 Report Posted January 22, 2015 yes man... ante marii... adiii... akkada... intwr ea typ o adagaledhu kadaa aniiii!!!!!
sukha_purushudu Posted January 23, 2015 Report Posted January 23, 2015 Jai Balayya man... correct the spelling man...
sukha_purushudu Posted February 4, 2015 Report Posted February 4, 2015 yes man... SSIS Class start chesava ?
Recommended Posts