qwerty1204 Posted March 8, 2012 Author Report Posted March 8, 2012 Oka question baa suppose I have a file having content like this Filename: SAMPLE1 Col 1 Col 2 Col 3 Col4 1 A "" "" 2 "" B "" 3 "" "" C 4 D "" "" 5 "" E "" 6 "" "" F above content ni iko file lo kii pampali..in this format Filename: SAMPLE2 col1 col2 col3 col4 1 A B C 2 D E F how can we do this?? transformer stage lo loop condition ela use cheyaloo telusa baa ...nenu adhi use chesi cheyachu anukuntunna..but dont know how to implement it nenu ila anukuntunna...loop condition loo for every 3 rows in SAMPLE1 file..loop iterate avvali..so tht if i == 1 appudu A ni col2 (SAMPLE2 lo ni column) lo ki insert chesta..similarly if i==2 then B ni col3 lo ki insert chestha..and i == 3 then C ni col4 lo ki insert chestha...here "i" is a loop variable anukondi loop loo adhi ela chealioo evarikanna idea undaa
qwerty1204 Posted March 8, 2012 Author Report Posted March 8, 2012 SAMPLE1 file loo "" antee blank ani ardam and col1 for both the files are nothing but a key column which is incrementing (i.e. 1..2..3 and so on....of course aa information avasaram leu..but data enti ani chepthunna )
dalapathi Posted March 8, 2012 Report Posted March 8, 2012 [quote name='arey ooo samba' timestamp='1331167989' post='1301490548'] Oka question baa suppose I have a file having content like this Filename: SAMPLE1 Col 1 Col 2 Col 3 Col4 1 A "" "" 2 "" B "" 3 "" "" C 4 D "" "" 5 "" E "" 6 "" "" F above content ni iko file lo kii pampali..in this format Filename: SAMPLE2 col1 col2 col3 col4 1 A B C 2 D E F how can we do this?? transformer stage lo loop condition ela use cheyaloo telusa baa ...nenu adhi use chesi cheyachu anukuntunna..but dont know how to implement it nenu ila anukuntunna...loop condition loo for every 3 rows in SAMPLE1 file..loop iterate avvali..so tht if i == 1 appudu A ni col2 (SAMPLE2 lo ni column) lo ki insert chesta..similarly if i==2 then B ni col3 lo ki insert chestha..and i == 3 then C ni col4 lo ki insert chestha...here "i" is a loop variable anukondi loop loo adhi ela chealioo evarikanna idea undaa [/quote] maa colleague ki kuudaa telidantaa.........account vuntey DSXchange lo post vesi chuudu......
qwerty1204 Posted March 8, 2012 Author Report Posted March 8, 2012 [quote name='dalapathi' timestamp='1331220432' post='1301492884'] maa colleague ki kuudaa telidantaa.........account vuntey DSXchange lo post vesi chuudu...... [/quote] oka aproach trying baa..wrk aite..will let u know..
pandemkodi Posted March 12, 2012 Report Posted March 12, 2012 babu unix scripts vacha evarikina naaku unix script ela execute cheyyalo kuda teledu naaku filepath filename ishtey aa file name, toal files ,count ,date raavali total files ani enduku annanatey file name anedi single file avvachu or file patteren avvachu for example abc.txt or abc.* ila so please help
Silver_mani Posted March 13, 2012 Report Posted March 13, 2012 [quote name='pandemkodi' timestamp='1331579362' post='1301508265'] babu unix scripts vacha evarikina naaku unix script ela execute cheyyalo kuda teledu naaku filepath filename ishtey aa file name, toal files ,count ,date raavali total files ani enduku annanatey file name anedi single file avvachu or file patteren avvachu for example abc.txt or abc.* ila so please help [/quote] to count files :WC -l date ki , var = $ date
qwerty1204 Posted March 14, 2012 Author Report Posted March 14, 2012 [quote name='Silver_mani' timestamp='1331688667' post='1301513405'] mama evaraina SCD stage vadara ?? [/quote] baa but question ento seppu baa..will try
Silver_mani Posted March 14, 2012 Report Posted March 14, 2012 [quote name='arey ooo samba' timestamp='1331688782' post='1301513412'] baa but question ento seppu baa..will try [/quote] CDC stage vada mama ...antha clear gane vundi ... But if we use SCD stage, we can do direct dimension Update and Fact load . rendu okesari cheyyochanta ....adi elano teliyatledu
Silver_mani Posted March 14, 2012 Report Posted March 14, 2012 Evaru lera [img]http://i41.tinypic.com/291j8mr.jpg[/img]
Silver_mani Posted March 14, 2012 Report Posted March 14, 2012 [quote name='D.V.S.KARNA' timestamp='1331689706' post='1301513440'] nenu SCD vadutunna..wts up [/quote] asalu adi ela vadtaro koncham brief ga cheppu baa
qwerty1204 Posted March 14, 2012 Author Report Posted March 14, 2012 [quote name='Silver_mani' timestamp='1331688981' post='1301513417'] CDC stage vada mama ...antha clear gane vundi ... But if we use SCD stage, we can do direct dimension Update and Fact load . rendu okesari cheyyochanta ....adi elano teliyatledu [/quote] asalu ee dimensional fact anna words vintunte nee [img]http://lh6.ggpht.com/_vGgr3WUJEdg/S88wRLPevqI/AAAAAAAABl0/9NxybQn4vT4/ali%20cannot.gif[/img] dala baa vastadu emo chudamu
Silver_mani Posted March 14, 2012 Report Posted March 14, 2012 [quote name='arey ooo samba' timestamp='1331689874' post='1301513451'] asalu ee dimensional fact anna words vintunte nee [img]http://lh6.ggpht.com/_vGgr3WUJEdg/S88wRLPevqI/AAAAAAAABl0/9NxybQn4vT4/ali%20cannot.gif[/img] dala baa vastadu emo chudamu [/quote] Karna baa vadadanta ..chepatdu w8 . [img]http://i47.tinypic.com/e97l0h.jpg[/img]
Recommended Posts