Jump to content

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


Recommended Posts

Posted

[quote name='mrudhula99' timestamp='1360369822' post='1303250129']
online lo untundhii ga.. pdf..
[/quote]
adi dorkake adgedi,... kudirthe vethiki ivvu [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]

Posted

[quote name='Silver_mani' timestamp='1360360597' post='1303249599']
water taagandi ...automatic gaa anni artham aipotayi
[/quote]
[img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]

Posted

[quote name='soldier' timestamp='1360339834' post='1303247653']
May be...Its based on Environment tooo.Meedi peddadi haa?Antee like Madi ayitee DEv lo around 8,000 jobs unnayiii!!!
[/quote]
j&*[size=4] [/size][size=4] j&*[/size]

Posted

[quote name='arey ooo samba' timestamp='1360348326' post='1303248676']

DS jobs ni command line nunchi ela run chestamo oka example tho cheppu baa

nenu comand line open chesthe

[b]istool>[/b]

ani undi

so akkada nunchi what are steps to follow to run a job in my project <)&
[/quote]
istool> ekkada untundhii assalu.. unix lo chusavaa

Posted

oka seq file lo ki data load cheyali baa

ela ante

first header record load cheyali then

data records load cheyali (at max 100 untayi data records)

and then again next header record load cheyali...followed by its data records

ikkada header record and data record lenght are the same (even though header is having only 4 columns and data record is having 10 columns..then lenght is the same)

ee scenario ni ela design ceyali baa...DS job loo

Posted

[quote name='arey ooo samba' timestamp='1360717925' post='1303269147']
oka seq file lo ki data load cheyali baa

ela ante

first header record load cheyali then

data records load cheyali (at max 100 untayi data records)

and then again next header record load cheyali...followed by its data records

ikkada header record and data record lenght are the same (even though header is having only 4 columns and data record is having 10 columns..then lenght is the same)

ee scenario ni ela design ceyali baa...DS job loo
[/quote]
nee banda bada ...andulo emundi baa ...fixed lenghts vunte easy ne kada

Posted

[quote name='Silver_mani' timestamp='1360718850' post='1303269212']
nee banda bada ...andulo emundi baa ...fixed lenghts vunte easy ne kada
[/quote]

adhee ela output ki rayali ani

naa job design ila undi

DatabaseStage--->Transformer----> OutputSeqFile (I know its not right, but all I have now is just a prototype job now)


ikkada database nunchi retrieve chesina records lo nunchi header record generate cheyali..like oka 100 records comes under a single header record (header record lo column total_amount ani untadi...aa value anedi aa 100 records lo ni amount column sum ayyi undali)

hope u got the point.

Posted

[quote name='arey ooo samba' timestamp='1360722408' post='1303269406']

adhee ela output ki rayali ani

naa job design ila undi

DatabaseStage--->Transformer----> OutputSeqFile (I know its not right, but all I have now is just a prototype job now)


ikkada database nunchi retrieve chesina records lo nunchi header record generate cheyali..like oka 100 records comes under a single header record (header record lo column total_amount ani untadi...aa value anedi aa 100 records lo ni amount column sum ayyi undali)

hope u got the point.
[/quote]
db nuncha ............ hmmm aithe koncham kashtame baa ....... no of records fixed kadu kada ?

Posted

[quote name='Silver_mani' timestamp='1360723038' post='1303269435']
db nuncha ............ hmmm aithe koncham kashtame baa ....... no of records fixed kadu kada ?
[/quote]

kadu baaa

oka header record kinda...100 or less detail records untayi...enni unnayi anedi...compute cheyali manamee

Posted

[quote name='arey ooo samba' timestamp='1360723151' post='1303269441']
kadu baaa

oka header record kinda...100 or less detail records untayi...enni unnayi anedi...compute cheyali manamee
[/quote]
baa clarity missing ....... sry naaku artham kavatle .....nuv paian cheppina requirement lo aithe pakka sequential file lo cheyyalevu ...it wont support

Posted

[quote name='Silver_mani' timestamp='1360723376' post='1303269452']
baa clarity missing ....... sry naaku artham kavatle .....nuv paian cheppina requirement lo aithe pakka sequential file lo cheyyalevu ...it wont support
[/quote]

since its a fixed width for both header and detail record...i thought of writing to a seq file having a single column (the length of the column is same as the incoming record lenght)

Posted

[quote name='arey ooo samba' timestamp='1360723745' post='1303269474']

since its a fixed width for both header and detail record...i thought of writing to a seq file having a single column (the length of the column is same as the incoming record lenght)
[/quote]
fixed width ok baa ....but header ki 4 col , records ki 10 col antunnav .... so seq file lo rendu records metadata (columns ) ela define chestav.....it wont support

Posted

[quote name='Silver_mani' timestamp='1360723976' post='1303269493']
fixed width ok baa ....but header ki 4 col , records ki 10 col antunnav .... so seq file lo rendu records metadata (columns ) ela define chestav.....it wont support
[/quote]


ade baaa aa header 4 columns kalipi length 100 undi anukoo

so detail 10 columns kaplili kuda 100 ee untadi kabatti

nenu o/p seq file lo

okee column ni define chesi dani length 100 ani istaa :4_12_13:

Posted

[quote name='arey ooo samba' timestamp='1360724222' post='1303269509']
ade baaa aa header 4 columns kalipi length 100 undi anukoo

so detail 10 columns kaplili kuda 100 ee untadi kabatti

nenu o/p seq file lo

okee column ni define chesi dani length 100 ani istaa :4_12_13:
[/quote]
length okkate saripodu baa ..... columns should be properly delimited so that you can distinguish the columns ...

Posted

[quote name='Silver_mani' timestamp='1360724443' post='1303269523']
length okkate saripodu baa ..... columns should be properly delimited so that you can distinguish the columns ...
[/quote]

hmm...it okk to have no record delimeter in a file kada baa...(in general client maaku pampe files loo delimeters emi undavu between columns)

×
×
  • Create New...