dkchinnari Posted February 24, 2012 Report Share Posted February 24, 2012 [quote name='arey ooo samba' timestamp='1330062111' post='1301447278'] hyperion aa asalu aa tech kuda vinaledu baa [img]http://www.desigifs.com/sites/default/files/sql1fa.gif?1290170563[/img] SAP medaa vasthundi lee baa..REQ chalane unnayi gaa..ATB [/quote]hehe..mmm:) Link to comment Share on other sites More sharing options...
dalapathi Posted February 24, 2012 Report Share Posted February 24, 2012 [quote name='vishwamithra' timestamp='1330053586' post='1301446919'] dala ki emi radhu saami..[img]http://lh4.ggpht.com/_vGgr3WUJEdg/S9FNT2mDQzI/AAAAAAAABng/cnQGrMj1ACw/bemmii.gif[/img] [/quote] [img]http://lh4.ggpht.com/_vGgr3WUJEdg/S9FNT2mDQzI/AAAAAAAABng/cnQGrMj1ACw/bemmii.gif[/img][img]http://lh4.ggpht.com/_vGgr3WUJEdg/S9FNT2mDQzI/AAAAAAAABng/cnQGrMj1ACw/bemmii.gif[/img][img]http://lh4.ggpht.com/_vGgr3WUJEdg/S9FNT2mDQzI/AAAAAAAABng/cnQGrMj1ACw/bemmii.gif[/img] Link to comment Share on other sites More sharing options...
dalapathi Posted February 24, 2012 Report Share Posted February 24, 2012 [quote name='McDowellMurthy' timestamp='1330059287' post='1301447155'] I tried to pass the values as below. Command:ksh Parameter:#/datastage/scripts#/main_script.sh #datastage/scripts/script_param.sh# This is not working..can some one pls help me out.. Thanks guys [/quote] aah parameter lo login details emanna avasaramemo......user ID & Password laagaa.......!!! Link to comment Share on other sites More sharing options...
dalapathi Posted February 24, 2012 Report Share Posted February 24, 2012 [quote name='D.V.S.KARNA' timestamp='1330053016' post='1301446897'] calling dalapathi baa..ikkada kottukuntunaru....[img]http://lh4.ggpht.com/_vGgr3WUJEdg/S9FNT2mDQzI/AAAAAAAABng/cnQGrMj1ACw/bemmii.gif[/img] [/quote] [quote name='arey ooo samba' timestamp='1330053250' post='1301446904'] ATB baa...wait cheyi kasepu DALA baa vastadu emo chudamu [/quote] maa dhagagra same template jobs.........anni files ki okatey paddati..........kaanei okko file lo okko change emanna vuntey,............dhanaiki transformer lo edho chinna chinana functions vaadatam thapap emie vundi saavadhu [img]http://lh4.ggpht.com/_vGgr3WUJEdg/S9FNT2mDQzI/AAAAAAAABng/cnQGrMj1ACw/bemmii.gif[/img][img]http://lh4.ggpht.com/_vGgr3WUJEdg/S9FNT2mDQzI/AAAAAAAABng/cnQGrMj1ACw/bemmii.gif[/img][img]http://lh4.ggpht.com/_vGgr3WUJEdg/S9FNT2mDQzI/AAAAAAAABng/cnQGrMj1ACw/bemmii.gif[/img] Link to comment Share on other sites More sharing options...
dkchinnari Posted February 24, 2012 Report Share Posted February 24, 2012 [quote name='dalapathi' timestamp='1330094046' post='1301447653'] [img]http://lh4.ggpht.com/_vGgr3WUJEdg/S9FNT2mDQzI/AAAAAAAABng/cnQGrMj1ACw/bemmii.gif[/img][img]http://lh4.ggpht.com/_vGgr3WUJEdg/S9FNT2mDQzI/AAAAAAAABng/cnQGrMj1ACw/bemmii.gif[/img][img]http://lh4.ggpht.com/_vGgr3WUJEdg/S9FNT2mDQzI/AAAAAAAABng/cnQGrMj1ACw/bemmii.gif[/img] [/quote] [quote name='dalapathi' timestamp='1330094757' post='1301447685'] maa dhagagra same template jobs.........anni files ki okatey paddati..........kaanei okko file lo okko change emanna vuntey,............dhanaiki transformer lo edho chinna chinana functions vaadatam thapap emie vundi saavadhu [img]http://lh4.ggpht.com/_vGgr3WUJEdg/S9FNT2mDQzI/AAAAAAAABng/cnQGrMj1ACw/bemmii.gif[/img][img]http://lh4.ggpht.com/_vGgr3WUJEdg/S9FNT2mDQzI/AAAAAAAABng/cnQGrMj1ACw/bemmii.gif[/img][img]http://lh4.ggpht.com/_vGgr3WUJEdg/S9FNT2mDQzI/AAAAAAAABng/cnQGrMj1ACw/bemmii.gif[/img] [/quote]naak teslu nee talent..db,nt kadha almsot all time[img]https://lh3.googleusercontent.com/-Z0Rqq1P1M8Q/Tz7ig82lvnI/AAAAAAAAAr0/q_shRqkwzNo/s298/1328280760670.gif[/img] Link to comment Share on other sites More sharing options...
dalapathi Posted February 24, 2012 Report Share Posted February 24, 2012 [quote name='vishwamithra' timestamp='1330094870' post='1301447693'] naak teslu nee talent..db,nt kadha almsot all time[img]https://lh3.googleusercontent.com/-Z0Rqq1P1M8Q/Tz7ig82lvnI/AAAAAAAAAr0/q_shRqkwzNo/s298/1328280760670.gif[/img] [/quote] [img]https://lh3.googleusercontent.com/-Z0Rqq1P1M8Q/Tz7ig82lvnI/AAAAAAAAAr0/q_shRqkwzNo/s298/1328280760670.gif[/img] Link to comment Share on other sites More sharing options...
CaliStar Posted February 24, 2012 Report Share Posted February 24, 2012 [quote name='vishwamithra' timestamp='1330061719' post='1301447269'] naadhi ee tech ardham katle baa..naake[img]http://www.desigifs.com/sites/default/files/sql1fa.gif?1290170563[/img] eeroje last day project lo..hyperion essbase midha..next ardham katle...sap anukuna..calls ratle[img]http://www.desigifs.com/sites/default/files/sql1fa.gif?1290170563[/img] [/quote] [color=#282828][font=helvetica, arial, sans-serif][img]http://www.desigifs.com/sites/default/files/sql1fa.gif?1290170563[/img][/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color] Link to comment Share on other sites More sharing options...
McDowellMurthy Posted March 2, 2012 Report Share Posted March 2, 2012 [color=#282828][font=helvetica, arial, sans-serif]Manchi Consultancies with Good Pay, cheppeskondi...[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Nenu Jump Jilaani maa consultancy nunchi.....[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]PLZ help [/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color] [color=#282828][font=helvetica, arial, sans-serif] [/font][/color] [color=#282828][font=helvetica, arial, sans-serif] [/font][/color] Link to comment Share on other sites More sharing options...
sujithrede Posted March 2, 2012 Report Share Posted March 2, 2012 bhayya.. ds positions vunte cheppandi.. nadi next week last proj Link to comment Share on other sites More sharing options...
qwerty1204 Posted March 5, 2012 Author Report Share Posted March 5, 2012 ninna oka interview loo ila adigadu.. how many dimensional and fact tables are there in your project? nenu edho appatikapudu..we are using start schema..so one dimensional and multiple fact ani chepaa google chesi chusanu..kani clear ga ardam kaledu..asalu dimensional and fact tables ante enti..oka example thoo cheppandi evaranaa Link to comment Share on other sites More sharing options...
pandemkodi Posted March 5, 2012 Report Share Posted March 5, 2012 naaku telisinanthavaraku for ex ippudu student vunnadu anukundam vaadi info antha oka table la vuntadi adi dimension table like stu name stu_sub stuA_prof ila idi dimension fact nothing but stu-avg_marks fact antey naaku telisinatha varaku its sholud be inn numbers like atu avg marks or student_attend_days like this general gaa maa project lo 150 tables vuntey 120 varaku dimension and face 30 ala vunnai Link to comment Share on other sites More sharing options...
pandemkodi Posted March 5, 2012 Report Share Posted March 5, 2012 [quote name='McDowellMurthy' timestamp='1330653600' post='1301470412'] [color=#282828][font=helvetica, arial, sans-serif]Manchi Consultancies with Good Pay, cheppeskondi...[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Nenu Jump Jilaani maa consultancy nunchi.....[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]PLZ help [/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color] [color=#282828][font=helvetica, arial, sans-serif] [/font][/color] [color=#282828][font=helvetica, arial, sans-serif] [/font][/color] [/quote] naakkuda plz Link to comment Share on other sites More sharing options...
pandemkodi Posted March 5, 2012 Report Share Posted March 5, 2012 [color=#494949][font=Verdana, Arial, Helvetica, sans-serif][size=3]fact tables also typically have some kind of quantitative data. The quantity sold, the price per item, total price, and so on.[/size][/font][/color] [color=#494949][font=Verdana, Arial, Helvetica, sans-serif][size=3]Employees sell, customers buy. Employees and customers are examples of dimensions[/size][/font][/color] Link to comment Share on other sites More sharing options...
pandemkodi Posted March 5, 2012 Report Share Posted March 5, 2012 att store lo employees vuntaaru kada mama customer konadaaniki potaaru appudu employees edotu ammutaaru customer ki ee situation lo employee,customer anevi two dimension tables with their related data and amount they sold/price/avg price are facts(fact table) Link to comment Share on other sites More sharing options...
qwerty1204 Posted March 5, 2012 Author Report Share Posted March 5, 2012 [quote name='pandemkodi' timestamp='1330987399' post='1301482614'] att store lo employees vuntaaru kada mama customer konadaaniki potaaru appudu employees edotu ammutaaru customer ki ee situation lo employee,customer anevi two dimension tables with their related data and amount they sold/price/avg price are facts(fact table) [/quote] nuvvu cheppina example base chesukoni ee below points ki ela relate chestamoo konchem cheppu baa [color=#000000][font=Calibri,]1.Fact table - Table with Collection of [b]Foreign Keys corresponding to the Primary Keys in Dimensional table[/b]. Consists of fields with numeric values.[/font][/color] [color=#000000][font=Calibri,]2.Dimension table -[b] Table with Unique Primary Key.[/b][/font][/color] [color=#000000][font=Calibri,]3.Load -[b] Data should be first loaded into dimensional table. Based on the primary key values in dimensional table, the data should be loaded into Fact table.[/b][/font][/color] Link to comment Share on other sites More sharing options...
-1.thumb.png.613bdd33b4e8b5f69ac815bf90e62a8b.png)
Recommended Posts