qwerty1204 Posted February 1, 2013 Author Report Posted February 1, 2013 [quote name='Aamphat' timestamp='1359747379' post='1303206148'] [indent=1][font=arial][size=3]DS thru xml file generate chestuntey...ila vasthundi...data[/size][/font] [font=arial][size=3][color=#0000FF]<MaturityDate>[/color][/size][/font] [color=#0000FF][size=3][font=arial]2012-10-01[/font][/size][/color] [color=#0000FF][size=3][font=arial]</MaturityDate>[/font][/size][/color] [color=#0000FF][size=3][font=arial]<Amortization>[/font][/size][/color] [color=#0000FF][size=3][font=arial]141[/font][/size][/color] [color=#0000FF][size=3][font=arial]</Amortization>[/font][/size][/color] [color=#0000FF][size=3][font=arial]<Recourse>[/font][/size][/color] [color=#0000FF][size=3][font=arial]2[/font][/size][/color] [color=#0000FF][size=3][font=arial]</Recourse>[/font][/size][/color] [font=arial][size=3][b]But kavaalsindhi ila...[/b][/size][/font] [font=arial][size=3][color=#0000FF]<MaturityDate>2012-10-01</MaturityDate>[/color][/size][/font] [color=#0000FF][size=3][font=arial]<Amortization>141</Amortization>[/font][/size][/color] [color=#0000FF][size=3][font=arial]<Recourse>2</Recourse>[/font][/size][/color][/indent] [/quote] nuvvu generate cehse file name extension .xml ani iste....ala vachee chance undadu baa 1
vikuba Posted February 1, 2013 Report Posted February 1, 2013 [quote name='arey ooo samba' timestamp='1359751258' post='1303206729'] nuvvu generate cehse file name extension .xml ani iste....ala vachee chance undadu baa [/quote] pakka..?.i will suggest this to my dev if its a verified solution but maavodu .xml lagey isthundu
Manthrii Posted February 1, 2013 Report Posted February 1, 2013 [quote name='arey ooo samba' timestamp='1359746771' post='1303206085'] complex flat file stage lo ki data insert cheyali in that case...can I define multiple record layouts in the input tab of the CFF stage (I tried but create nultiple record layouts, but the option is disabled)? in general oka file lo multpile record layouts unte..danni CFF stage use chesi read chestamu...at tht time output tab of CFF stage lo aa multiple record layout's ni define chesi we can retrieve the data out of it but ikkada naaku CFF stage/file lo ki multiple record layout unna data ni rayalii..ela [/quote] akkada single record lo read cheyyatam veru multiple records layout lo read cheyyatam veru baa.. based on the copy book.. you need to decide,
qwerty1204 Posted February 1, 2013 Author Report Posted February 1, 2013 [quote name='Aamphat' timestamp='1359751647' post='1303206766'] pakka..?.i will suggest this to my dev if its a verified solution but maavodu .xml lagey isthundu [/quote] the reason being is...if you open up any xml file...it should be in a hierarchical format..
Silver_mani Posted February 1, 2013 Report Posted February 1, 2013 [quote name='Aamphat' timestamp='1359747379' post='1303206148'] [indent=1][font=arial][size=3]DS thru xml file generate chestuntey...ila vasthundi...data[/size][/font] [font=arial][size=3][color=#0000ff]<MaturityDate>[/color][/size][/font] [color=#0000ff][size=3][font=arial]2012-10-01[/font][/size][/color] [color=#0000ff][size=3][font=arial]</MaturityDate>[/font][/size][/color] [color=#0000ff][size=3][font=arial]<Amortization>[/font][/size][/color] [color=#0000ff][size=3][font=arial]141[/font][/size][/color] [color=#0000ff][size=3][font=arial]</Amortization>[/font][/size][/color] [color=#0000ff][size=3][font=arial]<Recourse>[/font][/size][/color] [color=#0000ff][size=3][font=arial]2[/font][/size][/color] [color=#0000ff][size=3][font=arial]</Recourse>[/font][/size][/color] [font=arial][size=3][b]But kavaalsindhi ila...[/b][/size][/font] [font=arial][size=3][color=#0000ff]<MaturityDate>2012-10-01</MaturityDate>[/color][/size][/font] [color=#0000ff][size=3][font=arial]<Amortization>141</Amortization>[/font][/size][/color] [color=#0000ff][size=3][font=arial]<Recourse>2</Recourse>[/font][/size][/color][/indent] [/quote] i guess ur using xml_output stage ...in that case you can do this output -- Tansformation Settings - Output mode -- AGGREGATE ALL ROWS appudu neeku single line xml generate aipotundi
Silver_mani Posted February 1, 2013 Report Posted February 1, 2013 [quote name='Manthrii' timestamp='1359751746' post='1303206778'] akkada single record lo read cheyyatam veru multiple records layout lo read cheyyatam veru baa.. based on the copy book.. you need to decide, [/quote] agreed ....gp
qwerty1204 Posted February 1, 2013 Author Report Posted February 1, 2013 [quote name='Manthrii' timestamp='1359751746' post='1303206778'] akkada single record lo read cheyyatam veru multiple records layout lo read cheyyatam veru baa.. based on the copy book.. you need to decide, [/quote] I don't have any problem in reading a multiple record layout file baa my REQ is to [b]create[/b] a multi records layout file for example: I want to create a file called sample.txt in that sample.txt the first record would be a header record having 4 columns (the total length of the 4 columns in 100 bytes) and from second record would be a detail records having 10 columns (the total length of the 4 columns in 100 bytes) so the length of the file is fixed width only. how to achieve the above case
Silver_mani Posted February 1, 2013 Report Posted February 1, 2013 [quote name='arey ooo samba' timestamp='1359752942' post='1303206929'] I don't have any problem in reading a multiple record layout file baa my REQ is to [b]create[/b] a multi records layout file for example: I want to create a file called sample.txt in that sample.txt the first record would be a header record having 4 columns (the total length of the 4 columns in 100 bytes) and from second record would be a detail records having 10 columns (the total length of the 4 columns in 100 bytes) so the length of the file is fixed width only. how to achieve the above case [/quote] nee input ye stage baa ??
Manthrii Posted February 1, 2013 Report Posted February 1, 2013 [quote name='arey ooo samba' timestamp='1359752942' post='1303206929'] I don't have any problem in reading a multiple record layout file baa my REQ is to [b]create[/b] a multi records layout file for example: I want to create a file called sample.txt in that sample.txt the first record would be a header record having 4 columns (the total length of the 4 columns in 100 bytes) and from second record would be a detail records having 10 columns (the total length of the 4 columns in 100 bytes) so the length of the file is fixed width only. how to achieve the above case [/quote] first lo copy books tho read chesi try cheyyee baa. incase adhi workout aavvakunte max record length entha undho chusi adhi character field and the max record length layout tho define chesi read chesthe work avvvochu. ma dhaggara atlane chesam,
qwerty1204 Posted February 1, 2013 Author Report Posted February 1, 2013 [quote name='Silver_mani' timestamp='1359753078' post='1303206943'] nee input ye stage baa ?? [/quote] input database lo nunchu read chesi... output seq file lo ki load cheyali baa here the output seq file is having both header and data record in it...
Silver_mani Posted February 1, 2013 Report Posted February 1, 2013 [quote name='arey ooo samba' timestamp='1359753331' post='1303206979'] input database lo nunchu read chesi... output seq file lo ki load cheyali baa here the output seq file is having both header and data record in it... [/quote] 2 different layouts tho 2 records define chesko baa .....naaku problem ento artham kale or may be i didnt understand ur question properly
qwerty1204 Posted February 1, 2013 Author Report Posted February 1, 2013 [quote name='Manthrii' timestamp='1359753119' post='1303206949'] first lo copy books tho read chesi try cheyyee baa. incase adhi workout aavvakunte max record length entha undho chusi adhi character field and the max record length layout tho define chesi read chesthe work avvvochu. ma dhaggara atlane chesam, [/quote] asalu copy books ante ento teliyadu baa naaku as I mentioned before...I have to create an output file with multiple record layout (the length of the header and detail record is same...its just the change in number of columns)....my source is cmng from a database
Manthrii Posted February 1, 2013 Report Posted February 1, 2013 [quote name='arey ooo samba' timestamp='1359753609' post='1303207041'] asalu copy books ante ento teliyadu baa naaku as I mentioned before...I have to create an output file with multiple record layout (the length of the header and detail record is same...its just the change in number of columns)....my source is cmng from a database [/quote] aithe easy mama. akkada oka field define sesko. character and length ivvu record length. it should work
qwerty1204 Posted February 1, 2013 Author Report Posted February 1, 2013 [quote name='Silver_mani' timestamp='1359753586' post='1303207036'] [b]2 different layouts tho 2 records define chesko baa [/b].....naaku problem ento artham kale or may be i didnt understand ur question properly [/quote] yaa adhi eee...ela cheyaloo ardam avadam ledu baa...when I kept CFF stage as my output..naaku stage lo ki velli chuste..[b]Records[/b] tab loo [b]Single Record[/b] anee check box disale ayyi undi...how to enable it
Manthrii Posted February 1, 2013 Report Posted February 1, 2013 [quote name='arey ooo samba' timestamp='1359753748' post='1303207071'] yaa adhi eee...ela cheyaloo ardam avadam ledu baa...when I kept CFF stage as my output..naaku stage lo ki velli chuste..[b]Records[/b] tab loo [b]Single Record[/b] anee check box disale ayyi undi...how to enable it [/quote] click cheyye vayya.. enable ayyedhi. single record lo ne read cheyyali according to your requirement
Recommended Posts