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

[BhagatSingh]

help antey andharu vellipoyareeee

[dalapathi]

[quote name='BhagatSingh' timestamp='1332871749' post='1301565389']
datastage ela vundhi antaru...............chala financial ga chachhi brathiki vunna.....
[/quote]
Jobs...........Datastage lo antey.........emo mari.....ee madhya ekkuva vunnatlu anipinchatledhu...........last year maatram baagaa vundey.....Feb, Mar lo ekkuva kanipinchatledhu........kaanie neeku ETL side aye raavaali antey..........annie ETL tools kantey Datastage aey better anukuntaa......kaanie instant gaa job raavaali antye....maree antha ekkuva vundavu anukuntaa......

[qwerty1204]

[quote name='BhagatSingh' timestamp='1332871901' post='1301565405']
help antey andharu vellipoyareeee
[/quote]
manchi training ichee consultancy chusukoni..training tesukoo baa...pedda kastam ga emi undadu...jobs antava dala baa cheppi natlu..programming jobs anni volume lo undavu...

[BhagatSingh]

[quote name='dalapathi' timestamp='1332872139' post='1301565426']
Jobs...........Datastage lo antey.........emo mari.....ee madhya ekkuva vunnatlu anipinchatledhu...........last year maatram baagaa vundey.....Feb, Mar lo ekkuva kanipinchatledhu........kaanie neeku ETL side aye raavaali antey..........annie ETL tools kantey Datastage aey better anukuntaa......kaanie instant gaa job raavaali antye....maree antha ekkuva vundavu anukuntaa......
[/quote]
[quote name='arey ooo samba' timestamp='1332872295' post='1301565446']
manchi training ichee consultancy chusukoni..training tesukoo baa...pedda kastam ga emi undadu...jobs antava dala baa cheppi natlu..programming jobs anni volume lo undavu...
[/quote]

[qwerty1204]

transformer loo ee logic ela implement cheyali

incoming row lo oka column null aite we will forward that row to the output.. aa column null avvaka pothe..we need to split the input record to two records in the output....basic ga ikkada kavalisindi I need to generate a sequence number in the output based on the input column type i.e. input column null aite ..output sequence number should be incremented by one (1.2.3. and so on)..if not null then output number should be (1,2(for the first input record) 3,4(for the second input record) 5,6 and so on)

[dalapathi]

[quote name='arey ooo samba' timestamp='1333473621' post='1301593948']
transformer loo ee logic ela implement cheyali

incoming row lo oka column null aite we will forward that row to the output.. aa column null avvaka pothe..we need to split the input record to two records in the output....basic ga ikkada kavalisindi I need to generate a sequence number in the output based on the input column type i.e. input column null aite ..output sequence number should be incremented by one (1.2.3. and so on)..if not null then output number should be (1,2(for the first input record) 3,4(for the second input record) 5,6 and so on)
[/quote]
idhi vaadi chuudakapoyinavaa.....

[url="http://datastagetips.wordpress.com/2011/06/14/datastage-generate-row_number/"]http://datastagetips.wordpress.com/2011/06/14/datastage-generate-row_number/[/url]

oka vela aah column null ayithey idhi ivvu..........null kaakapothey.........neeku etla kaavalno daani tho aah input column vi last 3 chars first 3 characters ni vidadheesi...neeku nachian vidamgaa concatenate chesi chuudu.......

[pandemkodi]

[quote name='dalapathi' timestamp='1333475013' post='1301594030']
idhi vaadi chuudakapoyinavaa.....

[url="http://datastagetips.wordpress.com/2011/06/14/datastage-generate-row_number/"]http://datastagetips...ate-row_number/[/url]

oka vela aah column null ayithey idhi ivvu..........null kaakapothey.........neeku etla kaavalno daani tho aah input column vi last 3 chars first 3 characters ni vidadheesi...neeku nachian vidamgaa concatenate chesi chuudu.......
[/quote]
mama
ikkada different partitions lo vunna different rows ki same row_number vastondi kada mama

ala raakudadhu kada

for ex akkada ichinaattu for first partition
row_number
1
3
4
5

for second partition
row_number
2
4
5
8
so ippudu manaku 4,5 anedi repeat avvudhi but ala repaet avvkudhu kada

[qwerty1204]

[quote name='dalapathi' timestamp='1333475013' post='1301594030']
idhi vaadi chuudakapoyinavaa.....

[url="http://datastagetips.wordpress.com/2011/06/14/datastage-generate-row_number/"]http://datastagetips...ate-row_number/[/url]

oka vela aah column null ayithey idhi ivvu..........null kaakapothey.........neeku etla kaavalno daani tho aah input column vi last 3 chars first 3 characters ni vidadheesi...neeku nachian vidamgaa concatenate chesi chuudu.......
[/quote]

nenu ila cheyali ani anukuntunna baa


for example

1st input row: column not null kadu..so it has to split into two rows in output ..so I use the loop iteration variable and generate the output as 1 for the first row of output and 2 for the second row of the output.

2nd input row: column null anukoo..then output row should be numbered as 3

3rd input row: column again null anukoo then the output row shoulb be numbered as 4

4th input row: column not null anukoo..then we have two output rows numbered 5 and 6 (logic is same as for 1st input row case)

so overall ga enti ante..if input column is not null then it should go through the loop ..if not don't go to the loop condition..but how to keep track of the incrementing number anedhi naa question

[dalapathi]

[quote name='arey ooo samba' timestamp='1333476334' post='1301594111']

nenu ila cheyali ani anukuntunna baa


for example

1st input row: column not null kadu..so it has to split into two rows in output ..so I use the loop iteration variable and generate the output as 1 for the first row of output and 2 for the second row of the output.

2nd input row: column null anukoo..then output row should be numbered as 3

3rd input row: column again null anukoo then the output row shoulb be numbered as 4

4th input row: column not null anukoo..then we have two output rows numbered 5 and 6 (logic is same as for 1st input row case)

so overall ga enti ante..if input column is not null then it should go through the loop ..if not don't go to the loop condition..but how to keep track of the incrementing number anedhi naa question
[/quote]
ooh....nenu inaka oka column ni split cheyyaalemo anukunnaa........

daaniki edho vuntadhi kadaa MAX ani edho function vuntahdi anukuntaa...........previous daaniki aey value vundhi ani check chesukovatyaaniki anukuntaa.......

[qwerty1204]

[quote name='dalapathi' timestamp='1333476879' post='1301594167']
ooh....nenu inaka oka column ni split cheyyaalemo anukunnaa........

daaniki edho vuntadhi kadaa MAX ani edho function vuntahdi anukuntaa...........previous daaniki aey value vundhi ani check chesukovatyaaniki anukuntaa.......
[/quote]

yaa MAX function ee chustunna baa..chudali wrk avthundoo ledhooo ee case loo

[qwerty1204]

Right & Wrong

above given data loo naaku only until "Right" ee kavali..how to split (Transformer stage loo ee function use cheyali??)

[pandemkodi]

enti baa oka exapmle ivvu

[qwerty1204]

[quote name='pandemkodi' timestamp='1333644043' post='1301602674']
enti baa oka exapmle ivvu
[/quote]

Input column lo data ila undi anukoo baa


TOM & RICKY
ANDY & LILLY

aa above data lo nunchi output column loo naaku

TOM
ANDY

kavali

[pandemkodi]

[quote name='arey ooo samba' timestamp='1333644227' post='1301602688']

Input column lo data ila undi anukoo baa


TOM & RICKY
ANDY & LILLY

aa above data lo nunchi output column loo naaku

TOM
ANDY

kavali
[/quote]
antey neeku prati row lo ila abc&bbc

madyalo & symbol vuntadha

[qwerty1204]

[quote name='pandemkodi' timestamp='1333644300' post='1301602690']
antey neeku prati row lo ila abc&bbc

madyalo & symbol vuntadha
[/quote]

avnu baa
..transformer loo ee funtion use chesi strip cheyaloo adram avvatledu