dalapathi Posted April 5, 2012 Report Share Posted April 5, 2012 [quote name='arey ooo samba' timestamp='1333648562' post='1301602944'] enti baa adhi..we have to give..substring value aa akkada [/quote] evo konni functions vuntaayi..........char(13) new line teeseyyataaniki anukuntaa..........idhikuudaa atlaantidhi ehdo anukuntaa Link to comment Share on other sites More sharing options...
qwerty1204 Posted April 5, 2012 Author Report Share Posted April 5, 2012 [quote name='dalapathi' timestamp='1333653236' post='1301603508'] evo konni functions vuntaayi..........char(13) new line teeseyyataaniki anukuntaa..........idhikuudaa atlaantidhi ehdo anukuntaa [/quote] oh kk baa inko doubt baa incoming 15 records unnayi..output lo naaku 10 records ee kavali..so transformer constraint lo condition mention chesi..aa 5 records ni raakunda chesanu...eppudu one of the output column should be an index (like incrementing sequence laga 1.2.3. and so on to 10) aa output column column derivation lo emani ivvali to get the numbers frm 1 to 10 Link to comment Share on other sites More sharing options...
dalapathi Posted April 5, 2012 Report Share Posted April 5, 2012 [quote name='arey ooo samba' timestamp='1333656635' post='1301603809'] oh kk baa inko doubt baa incoming 15 records unnayi..output lo naaku 10 records ee kavali..so transformer constraint lo condition mention chesi..aa 5 records ni raakunda chesanu...eppudu one of the output column should be an index (like incrementing sequence laga 1.2.3. and so on to 10) aa output column column derivation lo emani ivvali to get the numbers frm 1 to 10 [/quote] Idhi ichi chuudu (@INROWNUM - 1) * @NUMPARTITIONS + @PARTITIONNUM + 1 [url="http://datastagetips.wordpress.com/2011/06/14/datastage-generate-row_number/"]http://datastagetips.wordpress.com/2011/06/14/datastage-generate-row_number/[/url] Link to comment Share on other sites More sharing options...
qwerty1204 Posted April 5, 2012 Author Report Share Posted April 5, 2012 [quote name='dalapathi' timestamp='1333658215' post='1301603916'] Idhi ichi chuudu (@INROWNUM - 1) * @NUMPARTITIONS + @PARTITIONNUM + 1 [url="http://datastagetips.wordpress.com/2011/06/14/datastage-generate-row_number/"]http://datastagetips...ate-row_number/[/url] [/quote] adhi try chesanu baa..wrk avvaledu for example input rows numbers 1 2 3 and so on 15 daka unnayi out of which 5 rows doesn't meet the constraint in transformer(those 5 rows are numbered 3 6 7 11 14 ) eppudu aa above nuvvu chepindi use chesthe..we dont get the output rows in a sequence baa..soo andhukee irrespective or incoming rows..is there any function tht can generate sequence of numbers in output column? Link to comment Share on other sites More sharing options...
dalapathi Posted April 5, 2012 Report Share Posted April 5, 2012 [quote name='arey ooo samba' timestamp='1333658686' post='1301603962'] adhi try chesanu baa..wrk avvaledu for example input rows numbers 1 2 3 and so on 15 daka unnayi out of which 5 rows doesn't meet the constraint in transformer(those 5 rows are numbered 3 6 7 11 14 ) eppudu aa above nuvvu chepindi use chesthe..we dont get the output rows in a sequence baa..soo andhukee irrespective or incoming rows..is there any function tht can generate sequence of numbers in output column? [/quote] aah logic ikkada kaakundaa.......adhi drop ayina taruvaata.......next inko transformer petti....andhulo ee extra column add chesi daani derivation lo ivvu..........appudu akkada 10 rows aey vuntaayi kadaa.........aah 10 rows ki 1-10 vastaayi numbers........ oka transformer extra kaanie work ayithey avuthadhi anukuntaa Link to comment Share on other sites More sharing options...
qwerty1204 Posted April 5, 2012 Author Report Share Posted April 5, 2012 [quote name='dalapathi' timestamp='1333659287' post='1301604004'] aah logic ikkada kaakundaa.......adhi drop ayina taruvaata.......next inko transformer petti....andhulo ee extra column add chesi daani derivation lo ivvu..........appudu akkada 10 rows aey vuntaayi kadaa.........aah 10 rows ki 1-10 vastaayi numbers........ oka transformer extra kaanie work ayithey avuthadhi anukuntaa [/quote] yaa aa approach aite wrk avthundi baa...kakapothe maa lead gadu edustadu Link to comment Share on other sites More sharing options...
dalapathi Posted April 5, 2012 Report Share Posted April 5, 2012 [quote name='arey ooo samba' timestamp='1333659434' post='1301604012'] yaa aa approach aite wrk avthundi baa...kakapothe maa lead gadu edustadu [/quote] antey mee vaadu meeru chesey job designs annie chuustaadaa Link to comment Share on other sites More sharing options...
qwerty1204 Posted April 5, 2012 Author Report Share Posted April 5, 2012 [quote name='dalapathi' timestamp='1333659576' post='1301604019'] antey mee vaadu meeru chesey job designs annie chuustaadaa [/quote] ikkada fani thakkuva..cutting ekkuva baa...andhuke okadu develop chesina job mehda andharu padi edustaru DSXchange forum loo search chedamanna ela search cheyaoo ardam ayyi savadam ledu..neeku andhuloo search results emmana vasthe seffu baa Link to comment Share on other sites More sharing options...
pandemkodi Posted April 5, 2012 Report Share Posted April 5, 2012 Data string '2011/12/' does not match format '%dd%mm%yyyy': an integer was expected to match tag %yyyy. ee error vastondi mamas source data vachi 2011/12/01 Link to comment Share on other sites More sharing options...
qwerty1204 Posted April 5, 2012 Author Report Share Posted April 5, 2012 [quote name='pandemkodi' timestamp='1333659993' post='1301604038'] Data string '2011/12/' does not match format '%dd%mm%yyyy': an integer was expected to match tag %yyyy. ee error vastondi mamas source data vachi 2011/12/01 [/quote] date type length 10 ani mention chesi undoo chudu baa..and other thng is 2011-12-01 ala pass cheyali anukuntaa as input Link to comment Share on other sites More sharing options...
pandemkodi Posted April 5, 2012 Report Share Posted April 5, 2012 randi babu randi poddunnunchi kottuku sastunna nenu naa file lo rendu dates tagladdy okatemo yyyy/mm/dd ani vastondi inkotemo yyyy-mm-dd ani vastondi Link to comment Share on other sites More sharing options...
pandemkodi Posted April 5, 2012 Report Share Posted April 5, 2012 date field ki 10 ani icha baa Link to comment Share on other sites More sharing options...
qwerty1204 Posted April 5, 2012 Author Report Share Posted April 5, 2012 [quote name='pandemkodi' timestamp='1333659993' post='1301604038'] Data string '2011/12/' does not match format '%dd%mm%yyyy':[b] an integer was expected to match tag %yyyy[/b]. ee error vastondi mamas source data vachi 2011/12/01 [/quote] expected value emo dd/mm/yyyy format kada baa if you give input as 2011/12[b]/[/b]01 as input then the "/" symbol ..... it is tryng to treat as integer and gives us the error Link to comment Share on other sites More sharing options...
qwerty1204 Posted April 5, 2012 Author Report Share Posted April 5, 2012 ala oke file loo two types of date format unte (like yyyy/mm/dd and yyyy-mm-dd) better use a tranformer stage and make them as consistent.. like output the entire daya in a single format as yyyy-mm-dd Link to comment Share on other sites More sharing options...
pandemkodi Posted April 5, 2012 Report Share Posted April 5, 2012 [quote name='arey ooo samba' timestamp='1333660911' post='1301604070'] expected value emo dd/mm/yyyy format kada baa if you give input as 2011/12[b]/[/b]01 as input then the "/" symbol ..... it is tryng to treat as integer and gives us the error [/quote] antey ds default gaa dd/mm/yyyy teskuntada baaa mari naa date yyyy/mm/dd vastondi Link to comment Share on other sites More sharing options...
Recommended Posts