Jump to content

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


Recommended Posts

Posted

[quote name='pandemkodi' timestamp='1333661076' post='1301604079']
antey ds default gaa dd/mm/yyyy teskuntada baaa
mari naa date yyyy/mm/dd vastondi
[/quote]

DS default entoo idea ledu baa..naa project lo aite default yyyy-mm-dd format ee baa....may be mee proj loo default dd/mm/yyyy set chesaru emo...

neeku error loo ee format aitee expect chestundoo ..aa format loo ivvu baa nee incoming record ni

Posted

[quote name='arey ooo samba' timestamp='1333661371' post='1301604092']

DS default entoo idea ledu baa..naa project lo aite default yyyy-mm-dd format ee baa....may be mee proj loo default dd/mm/yyyy set chesaru emo...

neeku error loo ee format aitee expect chestundoo ..aa format loo ivvu baa nee incoming record ni
[/quote]
ok try chesi choosta

Posted

[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 :4_12_13:
[/quote]

chivariki oka filter stage followed by a transformer stage use chesi chesa baa @3$%

Posted

manam ee thread ni ilaane padhi kaalaala paatu brathikinchali

Posted

[quote name='pandemkodi' timestamp='1333660708' post='1301604061']
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
[/quote]
iitial gaa annie varchar gaa read cheyyi........next oka transformer lo ereplace function vaadu

Ereplace(columnname,"-","/")

ani ivvu...........ippudu annie same format lo vuntaayi......

next inko transformer lo string to date ....function vaadu.....

StringToDate(columnname,"%yyyy/%(m,s)/%(m,s)")

ekkadainaa function lo chinnagaa atu itu vutey.,......check cheyyi......

ippudu annie work out avuhtaayi..........main gurthu pettukovalsindhi.......nuvvu string to date lo ichey format input data elaa vasthundoo adhi ivvali.......

99% idhi work out avvaali :4_12_13:

Posted

[quote name='dalapathi' timestamp='1333680358' post='1301604931']
iitial gaa annie varchar gaa read cheyyi........next oka transformer lo ereplace function vaadu

Ereplace(columnname,"-","/")

ani ivvu...........ippudu annie same format lo vuntaayi......

next inko transformer lo string to date ....function vaadu.....

StringToDate(columnname,"%yyyy/%(m,s)/%(m,s)")

ekkadainaa function lo chinnagaa atu itu vutey.,......check cheyyi......

ippudu annie work out avuhtaayi..........main gurthu pettukovalsindhi.......nuvvu string to date lo ichey format input data elaa vasthundoo adhi ivvali.......

99% idhi work out avvaali :4_12_13:
[/quote]

thanks baa
maa vaadu file format change chesaru ippudu antha correct vastondi data

Posted

DS lo java program ni ela run cheyali sSc_hidingsofa

incoming record ("String" type for examplr complete name like "MR ANDY NEWGUENS JR") ni java program ki input ga ichi...output of the java program i.e. (output will be of an array king having arr[0]="MR" arr[1]="ANDY" arr[2]="NEWGUENS" arr[3]="JR") ni malli DS loo output columns ki map cheyali :4_12_13:

normal ga DS lo aite split or substring or Field functions use chesi cheyachu..kakapothe..ikkada some extensive logic involved in those string parsing..andhukee there is an already written java program to parse that incoming string. :3D_Smiles_38:

Posted

[quote name='pandemkodi' timestamp='1333748003' post='1301608173']
thanks baa
maa vaadu file format change chesaru ippudu antha correct vastondi data
[/quote]
Ok....cool...... <)&

[quote name='arey ooo samba' timestamp='1333748549' post='1301608210']
DS lo java program ni ela run cheyali sSc_hidingsofa

incoming record ("String" type for examplr complete name like "MR ANDY NEWGUENS JR") ni java program ki input ga ichi...output of the java program i.e. (output will be of an array king having arr[0]="MR" arr[1]="ANDY" arr[2]="NEWGUENS" arr[3]="JR") ni malli DS loo output columns ki map cheyali :4_12_13:

normal ga DS lo aite split or substring or Field functions use chesi cheyachu..kakapothe..ikkada some extensive logic involved in those string parsing..andhukee there is an already written java program to parse that incoming string. :3D_Smiles_38:
[/quote]
No idea :3D_Smiles_38:

Posted

Bhayya inni rojulu DS Devs ki oka thread vundani teliyadu. I am a DS Dev too.

Posted

naaku telisi mettastar mama okkade DS Dev ee DB lo. Ippudu chala mandi vunnatlu vunnare.

Posted

[quote name='nandamuribidda' timestamp='1333749891' post='1301608296']
naaku telisi mettastar mama okkade DS Dev ee DB lo. Ippudu chala mandi vunnatlu vunnare.
[/quote]
))(< ))(<

Posted

[quote name='nandamuribidda' timestamp='1333749862' post='1301608294']
Bhayya inni rojulu DS Devs ki oka thread vundani teliyadu. I am a DS Dev too.
[/quote]

CITI_@w baa

nuvvu ee thread loo junior vi kabattie..nee SD cheppu :P

Posted

[quote name='arey ooo samba' timestamp='1333750346' post='1301608314']

CITI_@w baa

nuvvu ee thread loo junior vi kabattie..nee SD cheppu :P
[/quote]
junior kaadhu.........meekanna mundhu nundey chesthunnaadu........ :P :P :P

Posted

[quote name='dalapathi' timestamp='1333750649' post='1301608321']
junior kaadhu.........meekanna mundhu nundey chesthunnaadu........
[/quote]

:3D_Smiles:


nandamuribidda mazakkaa...baa ika ee thread loo nuvvu chupinchali nee thadakaa ))(<

ayna ee thread lo ki ivaala reply ichadu kada ani..junior annanu lee baa sSc_hidingsofa

eppati nunchi wrkng baa

×
×
  • Create New...