Jump to content

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


Recommended Posts

Posted

Finally Dsxchange lo join aipoina [img]http://lh6.ggpht.com/-puap4dh2Ouw/T-eJzg1AHfI/AAAAAAAAHCE/WdVCNe-bPhM/s150/PK-64.gif[/img][img]http://lh6.ggpht.com/-puap4dh2Ouw/T-eJzg1AHfI/AAAAAAAAHCE/WdVCNe-bPhM/s150/PK-64.gif[/img][img]http://lh6.ggpht.com/-puap4dh2Ouw/T-eJzg1AHfI/AAAAAAAAHCE/WdVCNe-bPhM/s150/PK-64.gif[/img]

Posted

thanks maams adi nenu unix lo chesa
naaku job lo oka error vastondi

Error occurred during data acquisition. All instances must proceed to call EndAcquisition function
idi TD connector lo sodhi laaga vundi konchem oka kanneyandi itu

Posted

randi babu randi
error vedi vedi ga vundi

Posted

[quote name='pandemkodi' timestamp='1341600820' post='1302090817']
thanks maams adi nenu unix lo chesa
naaku job lo oka error vastondi

Error occurred during data acquisition. All instances must proceed to call EndAcquisition function
idi TD connector lo sodhi laaga vundi konchem oka kanneyandi itu
[/quote]
artham kaledu mama

Posted

Direct ga cheyalemu baa in designer...kani oka long solution enti ante column names transformaer lo hard code chesi aa transformer and main source output links funnel ki ivvu..funnel lo execution sequential ani ivvu...but make sure hardcode chesinadi funnel ki first input and main source is second input.....i hope it can help.....




[quote name='pandemkodi' timestamp='1341514566' post='1302083345']
vayyas inko ka ti urgent
job ila vundi

database--->seq file
deenlo source lo col format ila vundi [b]col_1[/b] nenu file generate chesetappudu ila raavali [b]col-1[/b] but ds lo col name ila teeskotledu ela cheyyali naaku o/p [b]col-1 KAAVALI [/b]
[/quote]

Posted

[quote name='pandemkodi' timestamp='1341514566' post='1302083345']
vayyas inko ka ti urgent
job ila vundi

database--->seq file
deenlo source lo col format ila vundi [b]col_1[/b] nenu file generate chesetappudu ila raavali [b]col-1[/b] but ds lo col name ila teeskotledu ela cheyyali naaku o/p [b]col-1 KAAVALI [/b]
[/quote]
normal gaa read chesi.....seq. file output ki map cheyyi......next aah sequential file stage open chesi akkada coumn names lo manual gaa annie "_" vunna places lo "-" pettu

Itlaa chestey raavatledaa.......???

Posted

[quote name='dalapathi' timestamp='1341625959' post='1302093083']

normal gaa read chesi.....seq. file output ki map cheyyi......next aah sequential file stage open chesi akkada coumn names lo manual gaa annie "_" vunna places lo "-" pettu

Itlaa chestey raavatledaa.......???
[/quote]
Ala raadu mama
Ina idi nenu unix lo chesa mama sed tho

Posted

[quote name='kajri' timestamp='1341623086' post='1302093013']
Direct ga cheyalemu baa in designer...kani oka long solution enti ante column names transformaer lo hard code chesi aa transformer and main source output links funnel ki ivvu..funnel lo execution sequential ani ivvu...but make sure hardcode chesinadi funnel ki first input and main source is second input.....i hope it can help.....
[/quote]
File generate Ina tarvata sed command tho daanni replace chesa mama

Naaku inko error vachindi job lo
Piña VESA Choodu
Thanks mma

Posted

Paina esina error ardam kaledu....general ga oka doubt ...sed command use chesinapidu only first line lone data replace avutada leka complete file aa?...complete file avute adi wrong data avudi....i assume nuvvu ala cheyaledu ani... Aa command nenu vadaledu..so dont know.....but nenu chepina solution aithe long but without errors vastadi anukuntunna.....





[quote name='pandemkodi' timestamp='1341626723' post='1302093103']

File generate Ina tarvata sed command tho daanni replace chesa mama

Naaku inko error vachindi job lo
Piña VESA Choodu
Thanks mma
[/quote]

Posted

[quote name='pandemkodi' timestamp='1341626537' post='1302093099']
Ala raadu mama
Ina idi nenu unix lo chesa mama sed tho
[/quote]
ooh..........ok

Posted

[quote name='kajri' timestamp='1341627300' post='1302093114']
Paina esina error ardam kaledu....general ga oka doubt ...sed command use chesinapidu only first line lone data replace avutada leka complete file aa?...complete file avute adi wrong data avudi....i assume nuvvu ala cheyaledu ani... Aa command nenu vadaledu..so dont know.....but nenu chepina solution aithe long but without errors vastadi anukuntunna.....
[/quote]
sed lo 1st line lo avudhi and oka range lo kuda avvudhi (antey 1 to 5 lines ala ivvochu)
nenu use chesina command [b]sed -e 's/before-rec/after-rec/' filename >>newfile[/b]

ila redirect chesa last lo header lo name ni replace chesa
and pina
nenu vesina error TD connector lo data bulk access chestunety vastondi nenu update usechestunna

Posted

[b]sed -e '1,2s/before-rec/after-rec/' filename >>newfile[/b]
[b]ila ithey 1st and 2nd rows lo replace cheyyochu[/b]
[b]ala enni rows replace cheyyalo oka range ichi cheskovachu and redirect cheyyali new file ki [/b]

Posted

[color=#282828][font=helvetica, arial, sans-serif][img]http://25.media.tumblr.com/tumblr_m64n5z2XM21qawpudo1_250.gif[/img][/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color][color=#282828][font=helvetica, arial, sans-serif][img]http://25.media.tumblr.com/tumblr_m64n5z2XM21qawpudo1_250.gif[/img][/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color] [color=#282828][font=helvetica, arial, sans-serif][img]http://25.media.tumblr.com/tumblr_m64n5z2XM21qawpudo1_250.gif[/img][/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color]

Posted

babulu vunnarsa

idendo ee error artha ithaledu choodandi

[b]Error occurred during data acquisition. All instances must proceed to call EndAcquisition function[/b]

[b]TD [/b]connector error

×
×
  • Create New...