pandemkodi Posted March 14, 2012 Report Posted March 14, 2012 [quote name='Silver_mani' timestamp='1331691275' post='1301513574'] vammo tools kuda vuntaya......... thone cinema kanipistundi ...inka tools ante [img]http://i48.tinypic.com/dcy0l.jpg[/img] [/quote] vundi sachindi baa adey naa confusion meeru cdc annapudalla change capture stage aa leka cdc tool aa ani
Silver_mani Posted March 14, 2012 Report Posted March 14, 2012 [quote name='arey ooo samba' timestamp='1331691082' post='1301513561'] nenu tax payers data medha wrk chestanu baa..most of the data SSN's diff types of forms like 1099..1040 etc ala untayi...soo evi ee concept kindaki vasthayi..like star aa..SCD aa [/quote] adi kadu baa .... meeru ela model chestunnaru anedi mee tables batti cheppochu .....what kind of data is there in ur table ?? simple ga ante ... table lo values calculations, aggregations,sum etc etc vunte adi Facts
Silver_mani Posted March 14, 2012 Report Posted March 14, 2012 [quote name='pandemkodi' timestamp='1331691456' post='1301513580'] vundi sachindi baa adey naa confusion meeru cdc annapudalla change capture stage aa leka cdc tool aa ani [/quote] ante adi ela work aithadi baa ... aa tool table loki insert chestada ??
qwerty1204 Posted March 14, 2012 Author Report Posted March 14, 2012 [quote name='pandemkodi' timestamp='1331691398' post='1301513577'] baa start schma and snow flake schema anedi mana database designing concept scd anedi oka dimensional table type like slow gaa change ayye table type neeku telisey vuntadi type 1 lo history emi vuncham just overwrite chestam type 2 lo unlimited history preserve chestam type 3 limited [/quote] monna edho interview questions lo chusanu baa..dataware housing concepts ani..dimensional modelling (star and snow flake)..SCD..conceptual medlling ala types ani unnayi
pandemkodi Posted March 14, 2012 Report Posted March 14, 2012 [quote name='Silver_mani' timestamp='1331691581' post='1301513588'] ante adi ela work aithadi baa ... aa tool table loki insert chestada ?? [/quote] CDC agent ni source db lo install chestaru baa Adi logs meeda oracle lo ithey redo logs meeda work chestadi Changes oka threshold ki reach Ithey ola flatfile generate chestadi
qwerty1204 Posted March 14, 2012 Author Report Posted March 14, 2012 [quote name='Silver_mani' timestamp='1331691468' post='1301513583'] adi kadu baa .... meeru ela model chestunnaru anedi mee tables batti cheppochu .....what kind of data is there in ur table ?? simple ga ante ... table lo values calculations, aggregations,sum etc etc vunte adi Facts [/quote] oh kk...baa naa daily wrk ela untadi antee...naaku source-target mapping doc istaru..I will do the job development..so nenu ee dimensional..fact ani peddaga chudanu
Silver_mani Posted March 14, 2012 Report Posted March 14, 2012 [quote name='pandemkodi' timestamp='1331691847' post='1301513617'] CDC agent ni source db lo install chestaru baa Adi logs meeda oracle lo ithey redo logs meeda work chestadi Changes oka threshold ki reach Ithey ola flatfile generate chestadi [/quote] interesting baa ...kani DS kuda chala efficient ga chestundi ..............nenu inka PP gadini kabatti ... ranu ranu chudali ela vuntado [img]http://i41.tinypic.com/291j8mr.jpg[/img]
Silver_mani Posted March 14, 2012 Report Posted March 14, 2012 [quote name='arey ooo samba' timestamp='1331691954' post='1301513622'] oh kk...baa naa daily wrk ela untadi antee...naaku source-target mapping doc istaru..I will do the job development..so nenu ee dimensional..fact ani peddaga chudanu [/quote] okasari mee Db loki velli anni tables gelku mama ....most probably okko fact table okko process ni capture chestundi
pandemkodi Posted March 14, 2012 Report Posted March 14, 2012 [quote name='Silver_mani' timestamp='1331692035' post='1301513626'] interesting baa ...kani DS kuda chala efficient ga chestundi ..............nenu inka PP gadini kabatti ... ranu ranu chudali ela vuntado [img]http://i41.tinypic.com/291j8mr.jpg[/img] [/quote] Ee tool evvaru Vaadaru baa ekkuva
Silver_mani Posted March 14, 2012 Report Posted March 14, 2012 Mama inko doubt .... we can restrict a job to run on a single node ...Kani oka stage ni restrict cheyali ante ela?? Configuration file lo cheyyocha ?? ... ekkada vetikina correct ga evadu cheppaledu [img]http://i46.tinypic.com/98da8m.gif[/img]
qwerty1204 Posted March 14, 2012 Author Report Posted March 14, 2012 [quote name='Silver_mani' timestamp='1331692126' post='1301513630'] okasari mee Db loki velli anni tables gelku mama ....most probably okko fact table okko process ni capture chestundi [/quote] adhi anta california tax data baa...edhi padithe adhi open chesthe...dokkalo thanni dikki loo kurcho pedataru[img]http://www.desigifs.com/sites/default/files/sql1fa.gif[/img]
qwerty1204 Posted March 14, 2012 Author Report Posted March 14, 2012 [quote name='Silver_mani' timestamp='1331692704' post='1301513663'] Mama inko doubt .... we can restrict a job to run on a single node ...Kani oka stage ni restrict cheyali ante ela?? Configuration file lo cheyyocha ?? ... ekkada vetikina correct ga evadu cheppaledu [img]http://i46.tinypic.com/98da8m.gif[/img] [/quote] stage level loo kuda configuration file input ga ivvachu anukunta baa..
Silver_mani Posted March 14, 2012 Report Posted March 14, 2012 [quote name='arey ooo samba' timestamp='1331692875' post='1301513675'] adhi anta california tax data baa...edhi padithe adhi open chesthe...dokkalo thanni dikki loo kurcho pedataru[img]http://www.desigifs.com/sites/default/files/sql1fa.gif[/img] [/quote] mee project documentation lo chudu baa .... data model ela vundo ... [img]http://i45.tinypic.com/ivaf6p.gif[/img]
Silver_mani Posted March 14, 2012 Report Posted March 14, 2012 [quote name='arey ooo samba' timestamp='1331692956' post='1301513680'] stage level loo kuda configuration file input ga ivvachu anukunta baa.. [/quote] stage lo ekkada istam baa ... oka sample stage cheppava [img]http://i45.tinypic.com/ivaf6p.gif[/img]
qwerty1204 Posted March 14, 2012 Author Report Posted March 14, 2012 [quote name='Silver_mani' timestamp='1331693076' post='1301513691'] mee project documentation lo chudu baa .... data model ela vundo ... [img]http://i45.tinypic.com/ivaf6p.gif[/img] [/quote] will do [img]http://a.imageshack.us/img803/8713/alismile.gif[/img]
Recommended Posts