Silver_mani Posted February 13, 2013 Report Posted February 13, 2013 [quote name='arey ooo samba' timestamp='1360724605' post='1303269532'] hmm...it okk to have no record delimeter in a file kada baa...(in general client maaku pampe files loo delimeters emi undavu between columns) [/quote] baa em anuko pothe sample input , output .... atleast oka 2 records post chey
qwerty1204 Posted February 13, 2013 Author Report Posted February 13, 2013 [quote name='Silver_mani' timestamp='1360724764' post='1303269539'] baa em anuko pothe sample input , output .... atleast oka 2 records post chey [/quote] nenu DB nunchi read chese columns ila untayi ba DLN FNAME LNAME AMOUNT 120100 TOM HULA $35 120101 RICK BECKY $45 naa o/p seq file ila undali ba Header record format ila untai DLN_BATCH TOTAL_AMOUNT TOTAL_ITEMS 1201 $80 2 Detail format ila untadi DLN FNAME LNAME AMOUNT 120100 TOM HULA $35 120101 RICK BECKY $45 so detail record lo unna data is same as the one that we retrieved from Database header lo TOTAL_ITEMS ane column represents how many sub DLN's under this batch (which is 2) and TOTAL_AMOUNT is the summation of the amount fields the lengths of both header and detail are the same
Silver_mani Posted February 13, 2013 Report Posted February 13, 2013 [quote name='arey ooo samba' timestamp='1360725229' post='1303269572'] nenu DB nunchi read chese columns ila untayi ba DLN FNAME LNAME AMOUNT 120100 TOM HULA $35 120101 RICK BECKY $45 naa o/p seq file ila undali ba Header record format ila untai DLN_BATCH TOTAL_AMOUNT TOTAL_ITEMS 1201 $80 2 Detail format ila untadi DLN FNAME LNAME AMOUNT 120100 TOM HULA $35 120101 RICK BECKY $45 so detail record lo unna data is same as the one that we retrieved from Database header lo TOTAL_ITEMS ane column represents how many sub DLN's under this batch (which is 2) and TOTAL_AMOUNT is the summation of the amount fields the lengths of both header and detail are the same [/quote] first thing mama ..... oe batch ki oka batch(no of records ) ki ela distinguish chestav ? it it was a single batch ...you can sum up all the rows after ur calculations and add a new row which would be ur header .....else if you a fixed no of records n u can break then in to bacthces ...add header and refunnel them ....
qwerty1204 Posted February 13, 2013 Author Report Posted February 13, 2013 [quote name='Silver_mani' timestamp='1360726046' post='1303269620'] first thing mama ..... oe batch ki oka batch(no of records ) ki ela distinguish chestav ? it it was a single batch ...you can sum up all the rows after ur calculations and add a new row which would be ur header .....else if you a fixed no of records n u can break then in to bacthces ...add header and refunnel them .... [/quote] nenu indaka chepindi oka batch lo undee two records ..as you can see the belo example...the contents that we get from the database query is having multiple batches like 1201 is one batch....1202 is another batch [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]DLN FNAME LNAME AMOUNT[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]120100 TOM HULA $35[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]120101 RICK BECKY $45[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]120200 ROSS ANDREW $23[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]120201 GENIE YASMIN $12[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]120202 KAMAL JANSZ $16[/background][/size][/font][/color] header [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]DLN_BATCH TOTAL_AMOUNT TOTAL_ITEMS[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]1201 $80 2[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]1202 $51 3[/background][/size][/font][/color]
Silver_mani Posted February 13, 2013 Report Posted February 13, 2013 [quote name='arey ooo samba' timestamp='1360726618' post='1303269660'] nenu indaka chepindi oka batch lo undee two records ..as you can see the belo example...the contents that we get from the database query is having multiple batches like 1201 is one batch....1202 is another batch [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]DLN FNAME LNAME AMOUNT[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]120100 TOM HULA $35[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]120101 RICK BECKY $45[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]120200 ROSS ANDREW $23[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]120201 GENIE YASMIN $12[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]120202 KAMAL JANSZ $16[/background][/size][/font][/color] header [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]DLN_BATCH TOTAL_AMOUNT TOTAL_ITEMS[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]1201 $80 2[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]1202 $51 3[/background][/size][/font][/color] [/quote] generating ur header column is not a big deal .... the problem is you have to sum the records in 1 batch .... For that you use Transformer Variabes ...idi 8.5 nunchi available .........mottam type chese opika ledu baa ... google chey eg dorkutundi ..... artham kakapothe adugu
Silver_mani Posted February 13, 2013 Report Posted February 13, 2013 [quote name='Kaarthikeya' timestamp='1360727710' post='1303269751'] silver mayya simpestunnav rey [/quote] ...endi sattire aa ??
qwerty1204 Posted February 13, 2013 Author Report Posted February 13, 2013 [quote name='Silver_mani' timestamp='1360727419' post='1303269708'] [b]generating ur header column is not a big deal[/b] .... the problem is you have to sum the records in 1 batch .... For that you use Transformer Variabes ...idi 8.5 nunchi available .........mottam type chese opika ledu baa ... google chey eg dorkutundi ..... artham kakapothe adugu [/quote] header record ela generate chetamu baa as you can see the header record oka column emo sum of amounts...inko column emo total item count ee rendu oka aggreator stage lo ela calcualte chestamu baaa (is it possible to do sum and cnt (group by) on different columns in a single aggerator stage??) [b]the problem is you have to sum the records in 1 batch[/b] ananvu kada ante enti ardam kaledu
deals2buy Posted February 13, 2013 Report Posted February 13, 2013 [quote name='Silver_mani' timestamp='1360727987' post='1303269781'] ...endi sattire aa ?? [/quote] nee M rey.....ee time lo kuda vachi full help chestunnav ante
Silver_mani Posted February 13, 2013 Report Posted February 13, 2013 [quote name='arey ooo samba' timestamp='1360728000' post='1303269785'] header record ela generate chetamu baa as you can see the header record oka column emo sum of amounts...inko column emo total item count ee rendu oka aggreator stage lo ela calcualte chestamu baaa (is it possible to do sum and cnt (group by) on different columns in a single aggerator stage??) [b]the problem is you have to sum the records in 1 batch[/b] ananvu kada ante enti ardam kaledu [/quote] Assume u broke the data into multipe batches ... Send each batch throuch 1 link , then do the follwing sum of amounts = agrregation of all the rows in a column total item count = no of rows processed ( you can ccalculate this using a DS utility (predefined one )
Silver_mani Posted February 13, 2013 Report Posted February 13, 2013 [quote name='Kaarthikeya' timestamp='1360728127' post='1303269799'] nee M rey.....ee time lo kuda vachi full help chestunnav ante [/quote]
Manthrii Posted February 13, 2013 Report Posted February 13, 2013 [quote name='arey ooo samba' timestamp='1360726618' post='1303269660'] nenu indaka chepindi oka batch lo undee two records ..as you can see the belo example...the contents that we get from the database query is having multiple batches like 1201 is one batch....1202 is another batch [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]DLN FNAME LNAME AMOUNT[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]120100 TOM HULA $35[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]120101 RICK BECKY $45[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]120200 ROSS ANDREW $23[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]120201 GENIE YASMIN $12[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]120202 KAMAL JANSZ $16[/background][/size][/font][/color] header [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]DLN_BATCH TOTAL_AMOUNT TOTAL_ITEMS[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]1201 $80 2[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]1202 $51 3[/background][/size][/font][/color] [/quote] idhi nenu chesaa baa. easy ne
Silver_mani Posted February 13, 2013 Report Posted February 13, 2013 [quote name='Manthrii' timestamp='1360729415' post='1303269859'] idhi nenu chesaa baa. easy ne [/quote] explain flz
Manthrii Posted February 13, 2013 Report Posted February 13, 2013 detail records and header records saparate ga generate cheyye... header create cheyyatanki aggregator use chesa, fixed length annav kabati column names same ichela cheskoni funnel pettukunna.. next sort
Silver_mani Posted February 13, 2013 Report Posted February 13, 2013 [quote name='Manthrii' timestamp='1360729554' post='1303269869'] detail records and header records saparate ga generate cheyye... header create cheyyatanki aggregator use chesa, fixed length annav kabati column names same ichela cheskoni funnel pettukunna.. next sort [/quote] [img]http://www.manadb.com/Smileys/default/Brahmi.gif[/img][img]http://www.manadb.com/Smileys/default/Brahmi.gif[/img]
Recommended Posts