qwerty1204 Posted December 19, 2012 Author Report Posted December 19, 2012 [quote name='pandemkodi' timestamp='1355887638' post='1302978038'] neku correct idea vuntadi baa scenario ento so nuvvu implement chesi solution post cheyu...mrudula nenu cheppina tappu tappu antondi [/quote] haha... maa lead gadu sethaih type lee baa..vadiki oka laga kavali antadu...nuvvu cheppinavi kuda solutions ee baa...our team idea is to replace existing 4 jobs (4 tables are having this parent child relationship) with a single job with one DB2 connector stage as output and all the links are mapped to it
Manthrii Posted December 19, 2012 Report Posted December 19, 2012 [quote name='arey ooo samba' timestamp='1355889309' post='1302978172'] haha... maa lead gadu sethaih type lee baa..vadiki oka laga kavali antadu...nuvvu cheppinavi kuda solutions ee baa...our team idea is to replace existing 4 jobs (4 tables are having this parent child relationship) with a single job with one DB2 connector stage as output and all the links are mapped to it [/quote] workout aithe post cheyye baa..
Market Mastaan Posted December 19, 2012 Report Posted December 19, 2012 [quote name='mrudhula99' timestamp='1355878583' post='1302977211'] please dont spam here... mali venakki velli refer cheskovalante ibbandhi gaa untundhiii...... [/quote] neeku ala anipinchindaaaa....ooooh aithe ok..walkout sesithini..
lolliman Posted December 20, 2012 Report Posted December 20, 2012 baa naaku oka chinnaa doubt... I have one .csv file and It has lot of columns with like path\file1.avi path\file1.divx path\file1.srt path\file1.mp4 path\file1.avi path\path\file1.avi path\path\file1.avi path\path\file1.avi naa Q entante I just need rows which one have .avi , .divx and .mp4
lolliman Posted December 20, 2012 Report Posted December 20, 2012 [quote name='lolliman' timestamp='1356023566' post='1302987587'] baa naaku oka chinnaa doubt... I have one .csv file and It has lot of columns with like path\file1.avi path\file1.divx path\file1.srt path\file1.mp4 path\file1.avi path\path\file1.avi path\path\file1.avi path\path\file1.avi naa Q entante I just need rows which one have .avi , .divx and .mp4 [/quote] I got it reee
pandemkodi Posted December 20, 2012 Report Posted December 20, 2012 [quote name='lolliman' timestamp='1356023931' post='1302987657'] I got it reee [/quote] unix command use chesava leda ela cheppu konchem
lolliman Posted December 20, 2012 Report Posted December 20, 2012 [quote name='pandemkodi' timestamp='1356026566' post='1302988086'] unix command use chesava leda ela cheppu konchem [/quote] query transform lo where condition lo like use chesaaa baaaa and one more Q how to delete the path in the below set example: input [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.divx[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.srt[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.mp4[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\path\file1.av[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]output[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.divx[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.mp4[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.av[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]idi ela cheyyalo cheppu baa koncham[/background][/size][/font][/color]
lolliman Posted December 20, 2012 Report Posted December 20, 2012 [list] lolliman, pandemkodi, Facebook [/list] baa cheppu baaaa....
mrudhula99 Posted December 20, 2012 Report Posted December 20, 2012 [quote name='lolliman' timestamp='1356028502' post='1302988365'] query transform lo where condition lo like use chesaaa baaaa and one more Q how to delete the path in the below set example: input [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.divx[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.srt[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.mp4[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\path\file1.av[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]output[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.divx[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.mp4[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.av[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]idi ela cheyyalo cheppu baa koncham[/background][/size][/font][/color] [/quote] akkada like file name ichavaa??
mrudhula99 Posted December 20, 2012 Report Posted December 20, 2012 [quote name='lolliman' timestamp='1356028502' post='1302988365'] query transform lo where condition lo like use chesaaa baaaa and one more Q how to delete the path in the below set example: input [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.divx[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.srt[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.mp4[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\path\file1.av[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]output[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.divx[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.mp4[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.av[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]idi ela cheyyalo cheppu baa koncham[/background][/size][/font][/color] [/quote] akkada like file ichavaa??
lolliman Posted December 20, 2012 Report Posted December 20, 2012 [quote name='mrudhula99' timestamp='1356030512' post='1302988670'] akkada like file ichavaa?? [/quote] deenikanna mundu post choodu akkada like stmt ichaa and ippud path\path2\path15\file.avi lo naaku just file.avi kaavali
pandemkodi Posted December 20, 2012 Report Posted December 20, 2012 [quote name='lolliman' timestamp='1356028502' post='1302988365'] query transform lo where condition lo like use chesaaa baaaa and one more Q how to delete the path in the below set example: input [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.divx[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.srt[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.mp4[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\path\file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]path\path\file1.av[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]output[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.divx[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.mp4[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.avi[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]file1.av[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]idi ela cheyyalo cheppu baa koncham[/background][/size][/font][/color] [/quote] use this in sequntial file filter option sed -e 's/path//' filename
lolliman Posted December 20, 2012 Report Posted December 20, 2012 [quote name='mrudhula99' timestamp='1356030512' post='1302988670'] akkada like file ichavaa?? [/quote] my bad those are not same file names file1 _zzzz file2 abc file3xyz like this
pandemkodi Posted December 20, 2012 Report Posted December 20, 2012 you can use this command also sed 's/[PATH/]//g' filename above for direct reading into datastage sequential file if you want to redirect this to nes file and then read it through sequntial file then use sed 's/[PATH/]//g' filename >>newfilename
pandemkodi Posted December 20, 2012 Report Posted December 20, 2012 [quote name='lolliman' timestamp='1356023566' post='1302987587'] baa naaku oka chinnaa doubt... I have one .csv file and It has lot of columns with like path\file1.avi path\file1.divx path\file1.srt path\file1.mp4 path\file1.avi path\path\file1.avi path\path\file1.avi path\path\file1.avi naa Q entante I just need rows which one have .avi , .divx and .mp4 [/quote] nvuvu transformer lo like use chesava or sequntial file lo read chesepudu unix use chesava please explain
Recommended Posts