pandemkodi Posted February 22, 2013 Report Posted February 22, 2013 [quote name='dalapathi' timestamp='1361512833' post='1303313456'] business glossary ante aey table lo aey column ekkadi nundi vachindhi source ... final gaa presentation layer lo ekkada end ayyindhi emi chesinru madhyalo ani mapping gurinchi anukuntaa [/quote] Adi metadata workbench anykunta mama But call teeskoney knowledge ledu naaku andulo
qwerty1204 Posted February 23, 2013 Author Report Posted February 23, 2013 I have an incoming data like this ID CODE 081205 001 081205 002 081205 001 081205 002 081205 003 081206 003 081206 003 081206 001 [size=4]081206 003[/size][size=4] [/size] naa o/p lo ID CODE 081205 003 081206 003 ani ravali DS jobs lo ela chestamu
Silver_mani Posted February 23, 2013 Report Posted February 23, 2013 [quote name='arey ooo samba' timestamp='1361581883' post='1303317937'] I have an incoming data like this ID CODE 081205 001 081205 002 081205 001 081205 002 081205 003 081206 003 081206 003 081206 001 [size=4]081206 003[/size] naa o/p lo ID CODE 081205 003 081206 003 ani ravali DS jobs lo ela chestamu [/quote] its very easy mama ...... Aggregator stage vadu ....ID should be your key .... Code ki matram max value of the column optio vutadi chudu
qwerty1204 Posted February 23, 2013 Author Report Posted February 23, 2013 [quote name='Silver_mani' timestamp='1361585482' post='1303318103'] its very easy mama ...... Aggregator stage vadu ....ID should be your key .... Code ki matram max value of the column optio vutadi chudu [/quote] apart frm these two columns..there are few more columns that I have to pass in the downstream baa,,,,I know a way to split the incoming flow of records and do the aggregation and then recombine back by doing join or lookup...but main thng cheptamu marichitini....ippatikee job loo stages chala aypoyai and also cant really split the job into two....
Silver_mani Posted February 23, 2013 Report Posted February 23, 2013 [quote name='arey ooo samba' timestamp='1361586784' post='1303318224'] apart frm these two columns..there are few more columns that I have to pass in the downstream baa,,,,I know a way to split the incoming flow of records and do the aggregation and then recombine back by doing join or lookup...but main thng cheptamu marichitini....ippatikee job loo stages chala aypoyai and also cant really split the job into two.... [/quote] nee input stage ans output stage enti mama ...if ur connecting to any db ...idi sql lo chesesey ...its easy to handle that way
pandemkodi Posted February 23, 2013 Report Posted February 23, 2013 [quote name='Silver_mani' timestamp='1361587513' post='1303318289'] nee input stage ans output stage enti mama ...if ur connecting to any db ...idi sql lo chesesey ...its easy to handle that way [/quote] agreed use sql i need accom in portland,or
Silver_mani Posted February 23, 2013 Report Posted February 23, 2013 [quote name='pandemkodi' timestamp='1361587791' post='1303318315'] agreed use sql i need accom in portland,or [/quote] db lone vunnaru mama ...thread vey
Manthrii Posted February 23, 2013 Report Posted February 23, 2013 [quote name='arey ooo samba' timestamp='1361586784' post='1303318224'] apart frm these two columns..there are few more columns that I have to pass in the downstream baa,,,,I know a way to split the incoming flow of records and do the aggregation and then recombine back by doing join or lookup...but main thng cheptamu marichitini....ippatikee job loo stages chala aypoyai and also cant really split the job into two.... [/quote] transformer lo max value in the column theskoni pampochu anukunta ba.. chusi cheptha
gangster_rap Posted February 23, 2013 Report Posted February 23, 2013 emaiana datastage job vunte cheppandi
biddu Posted February 25, 2013 Report Posted February 25, 2013 [color=#282828][font=helvetica, arial, sans-serif]datastage developer ready i.e work from home but you have to come my place 3,500 Max Pay[/font][/color]
Terminator II Posted February 25, 2013 Report Posted February 25, 2013 [quote name='Silver_mani' timestamp='1361587513' post='1303318289'] nee input stage ans output stage enti mama ...if ur connecting to any db ...idi sql lo chesesey ...its easy to handle that way [/quote]
Silver_mani Posted February 26, 2013 Report Posted February 26, 2013 [quote name='kevkekaa' timestamp='1361808928' post='1303326184'] [/quote] sachinoda nee jimmadiponu
nani8055 Posted February 26, 2013 Report Posted February 26, 2013 [quote name='Silver_mani' timestamp='1361844434' post='1303329258'] sachinoda nee jimmadiponu [/quote] eda nersinav ro ee thitlu [b][color=#282828][b][size=5][color=#ff0000][img]http://manabalayya.com/forum/public/style_emoticons/default/r0wi7d.gif[/img][/color][/size][/b][/color][/b]
Silver_mani Posted February 26, 2013 Report Posted February 26, 2013 [quote name='nani8055' timestamp='1361845880' post='1303329304'] eda nersinav ro ee thitlu [b][color=#282828][b][size=5][color=#ff0000][img]http://manabalayya.com/forum/public/style_emoticons/default/r0wi7d.gif[/img][/color][/size][/b][/color][/b] [/quote]
qwerty1204 Posted February 26, 2013 Author Report Posted February 26, 2013 I am having XML content in a column which is stored in a dataset aa xml contetn lo parent tag ila untadi baa [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]<AA-Return returnVersion="2012v3.1" xmlns="http://www.example/efile" xmlns:irs="http://www.[/background][/size][/font][/color][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=2][background=rgb(234, 237, 244)]example[/background][/size][/font][/color][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]/efile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" [b]xsi:schemaLocation=" [/b][/background][/size][/font][/color][b][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][b][background=rgb(234, 237, 244)]file:///efile/PIT_RETURNS/Sample1.xsd" [/background][/b][/size][/font][/color][/b][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]>[/background][/size][/font][/color] [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]aa bold chesina content ni remove cheyali...transformer lo ela cheyachu baa[/background][/size][/font][/color] possible change ela undachu ante...aa red color lo unna part change avthaa untadii..for one xml to another xml [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]xsi:schemaLocation=" [/background][/size][/font][/color][b][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]file:///efile/PIT_RETURNS/[/background][/size][/font][/color][color=#ff0000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]Sample1[/background][/size][/font][/color][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)].xsd" [/background][/size][/font][/color][/b] [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]xsi:schemaLocation=" [/background][/size][/font][/color][b][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]file:///efile/PIT_RETURNS/[/background][/size][/font][/color][color=#ff0000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]Example[/background][/size][/font][/color][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)].xsd" [/background][/size][/font][/color][/b] [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]xsi:schemaLocation=" [/background][/size][/font][/color][b][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]file:///efile/PIT_RETURNS/[/background][/size][/font][/color][color=#ff0000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]Test[/background][/size][/font][/color][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)].xsd" [/background][/size][/font][/color][/b]
Recommended Posts