qwerty1204 Posted March 19, 2012 Author Report Share Posted March 19, 2012 [quote name='pandemkodi' timestamp='1332182590' post='1301533265'] cut -d "," -f4,5,6,7,8 filename---will give u only 4 5 6 7 8 columns ee command working avutondi baa unix lo ithey deenni seq file lo filter options lo petti choodu ostadi [/quote] thanx baa sequential file stage properties lo alanti option emi ledaa baa Link to comment Share on other sites More sharing options...
pandemkodi Posted March 19, 2012 Report Share Posted March 19, 2012 [quote name='arey ooo samba' timestamp='1332182763' post='1301533270'] thanx baa sequential file stage properties lo alanti option emi ledaa baa [/quote] seq file lo alantio option ledanukunta baa andukey filter option ichadu unix use cheskodaaniki Link to comment Share on other sites More sharing options...
qwerty1204 Posted March 19, 2012 Author Report Share Posted March 19, 2012 [quote name='pandemkodi' timestamp='1332183322' post='1301533292'] seq file lo alantio option ledanukunta baa andukey filter option ichadu unix use cheskodaaniki [/quote] oh kk..so parallel job lo matram cheyalemu antava..we have to run unix command outside of DS and get tht file as input to DS aa Link to comment Share on other sites More sharing options...
pandemkodi Posted March 19, 2012 Report Share Posted March 19, 2012 [quote name='arey ooo samba' timestamp='1332186443' post='1301533576'] oh kk..so parallel job lo matram cheyalemu antava..we have to run unix command outside of DS and get tht file as input to DS aa [/quote] no no seq file ee unix command ivvataniki oka option vundi adi filter aney option aa filter lo ee command ivvu baa vachestadi Link to comment Share on other sites More sharing options...
qwerty1204 Posted March 19, 2012 Author Report Share Posted March 19, 2012 [quote name='pandemkodi' timestamp='1332187540' post='1301533682'] no no seq file ee unix command ivvataniki oka option vundi adi filter aney option aa filter lo ee command ivvu baa vachestadi [/quote] yaa ippude aa option chusanu baa.. syntax same ee naa baa..unix loo edhi aite istamoo adhee command isthe enough aa Link to comment Share on other sites More sharing options...
pandemkodi Posted March 19, 2012 Report Share Posted March 19, 2012 [quote name='arey ooo samba' timestamp='1332187761' post='1301533708'] yaa ippude aa option chusanu baa.. syntax same ee naa baa..unix loo edhi aite istamoo adhee command isthe enough aa [/quote] yaa baa unix lo filename kuda istam kada but seq file stage lo filenmae akkarledu anukunta endukantey manm teeskoney file ee kada input Link to comment Share on other sites More sharing options...
pandemkodi Posted March 19, 2012 Report Share Posted March 19, 2012 first unix box lo test cheyy baaa ok anukunnaka aa filter lo pettu Link to comment Share on other sites More sharing options...
qwerty1204 Posted March 19, 2012 Author Report Share Posted March 19, 2012 The file I have doesn't have any column names in it baa...then how to do it Link to comment Share on other sites More sharing options...
pandemkodi Posted March 19, 2012 Report Share Posted March 19, 2012 [quote name='arey ooo samba' timestamp='1332188499' post='1301533779'] The file I have doesn't have any column names in it baa...then how to do it [/quote] column names tho panledu baa just delimiter anthey cut -d "," -f1,2 filename(unix box lo) daanlo 1,2 anevey columns and D tarvata quotes lo vunna , vundi choodu adi delimiter baa so nuvvu avi choostey chaalu names akkarla ikkada neeku 1,2 columns lo vunna data ni display chestadi unix lo and neeku kaavlsindi 4 to 8 kada cut -d "delimeter" -f4,5,6,7,8 filename Link to comment Share on other sites More sharing options...
qwerty1204 Posted March 19, 2012 Author Report Share Posted March 19, 2012 [quote name='pandemkodi' timestamp='1332189001' post='1301533837'] column names tho panledu baa just delimiter anthey cut -d "," -f1,2 filename(unix box lo) daanlo 1,2 anevey columns and D tarvata quotes lo vunna , vundi choodu adi delimiter baa so nuvvu avi choostey chaalu names akkarla ikkada neeku 1,2 columns lo vunna data ni display chestadi unix lo and neeku kaavlsindi 4 to 8 kada cut -d "delimeter" -f4,5,6,7,8 filename [/quote] yaa got it baa Link to comment Share on other sites More sharing options...
qwerty1204 Posted March 20, 2012 Author Report Share Posted March 20, 2012 konni interview questions about Dataware housing...vetiki answers simple ga ela cheppachoo cheppandi baa 1.What are the different Dimensional modeling Techniques are Available? 2. What is the Difference between Top-down Approach and Bottom-up Approach? 3. What is the life cycle of Data warehousing project? anni questions okee sari vesthe interest pothundi ani..dng it few at a time Link to comment Share on other sites More sharing options...
qwerty1204 Posted March 20, 2012 Author Report Share Posted March 20, 2012 [quote name='arey ooo samba' timestamp='1332267057' post='1301536894'] konni interview questions about Dataware housing...vetiki answers simple ga ela cheppachoo cheppandi baa 1.What are the different Dimensional modeling Techniques are Available? 2. What is the Difference between Top-down Approach and Bottom-up Approach? 3. What is the life cycle of Data warehousing project? anni questions okee sari vesthe interest pothundi ani..dng it few at a time [/quote] [color=#333333][size=4][font=arial, helvetica, sans-serif]1. [b]Star Schema:[/b][/font][/size][/color] [color=#333333][size=4][font=arial, helvetica, sans-serif][b]Snow Flake Schema:[/b][/font][/size][/color] [color=#333333][size=4][font=arial, helvetica, sans-serif][b]Galaxy Schema:[/b][/font][/size][/color] [color=#333333][size=4][font=arial, helvetica, sans-serif][b]Fact Constellation Schema:[/b][/font][/size][/color] [color=#333333][size=4][font=arial, helvetica, sans-serif]FOR ADDITIONAL INFO:[/font][/size][/color] [color=#333333][size=4][font=arial, helvetica, sans-serif][url="http://www.folkstalk.com/2010/01/data-warehouse-dimensional-modelling.html"]http://www.folkstalk...-modelling.html[/url][/font][/size][/color] [color=#333333][size=4][font=arial, helvetica, sans-serif]2. [color=#000000]top down design starts from abstract to finally achieve a solid design, bottom up approach is just the reverse as it begins with the concrete design to get to abstract entity. When it comes to designing brand new systems, it is top down approach that is most commonly employed. On the other hand, in the case of reverse [/color][url="http://www.differencebetween.com/category/business/engineering/"]engineering[/url][color=#000000] as when it is the goal to understand someone else’s design, bottom up approach is utilized.[/color][/font][/size][/color] [color=#333333][size=4][font=arial, helvetica, sans-serif]3. Datawarehousing projects are categorized into 4 types.[/font][/size][/color] [color=#333333][size=4][font=arial, helvetica, sans-serif]1) Development Projects. 2) Enhancement Projects 3) Migration Projects 4) Production support Projects.[/font][/size][/color] [color=#333333][size=4][font=arial, helvetica, sans-serif]-> The following are the different phases involved in a ETL project development life cycle.[/font][/size][/color] [color=#333333][size=4][font=arial, helvetica, sans-serif]1) Business Requirement Collection ( BRD ) 2) System Requirement Collection ( SRD ) 3) Design Phase a) High Level Design Document ( HRD ) Low level Design Document ( LLD ) c) Mapping Design 4) Code Review 5) Peer Review 6) Testing a) Unit Testing System Integration Testing. c) USer Acceptance Testing ( UAT ) 7) Pre - Production 8) Production ( Go-Live )[/font][/size][/color] Link to comment Share on other sites More sharing options...
Silver_mani Posted March 21, 2012 Report Share Posted March 21, 2012 Mama evaraina Modelling chesara ....Asalu ERwin tool ela vadtaro teliste cheppandi ....nenu ippudu modelling cheyali ...asalu ela start cheyalo artham kavatledu [img]http://i46.tinypic.com/98da8m.gif[/img] Link to comment Share on other sites More sharing options...
k2s Posted March 21, 2012 Report Share Posted March 21, 2012 datastage aa [img]http://i31.tinypic.com/11c6s2e.gif[/img] Link to comment Share on other sites More sharing options...
racharambola8 Posted March 21, 2012 Report Share Posted March 21, 2012 mamaaaaaaaaaaaaa emaindiiiiiiiiiii rammani pilichavuuuuuuuuuuuuuu Link to comment Share on other sites More sharing options...
Recommended Posts