@@@@calling All Datastage Developers@@@@

[dalapathi]

[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

[qwerty1204]

[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

[dalapathi]

[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]

[qwerty1204]

[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?

[dalapathi]

[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

[qwerty1204]

[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

[dalapathi]

[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

[qwerty1204]

[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

[pandemkodi]

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

[qwerty1204]

[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

[pandemkodi]

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

[pandemkodi]

date field ki 10 ani icha baa

[qwerty1204]

[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

[qwerty1204]

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

[pandemkodi]

[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