Jump to content

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


Recommended Posts

Posted

sort lo header starting naku CNTRL ani undedhi.. detail records lo SSAN ani undedhi.. format ila undedhiii

CNTRL SSAN 34ur394ir3904
SSAN 4398r4932834r390
SSAN 5489r439i342
.
.
CNTRL PPNA 482895824r
PPNA 85-24589--90
PPNA 8420573489--49

Posted

[quote name='Silver_mani' timestamp='1360729648' post='1303269873']
[img]http://www.manadb.com/Smileys/default/Brahmi.gif[/img][img]http://www.manadb.com/Smileys/default/Brahmi.gif[/img]
[/quote]
:3D_Smiles:[size=4] [/size][size=4] :3D_Smiles:[/size]

Posted

[quote name='Manthrii' timestamp='1360729743' post='1303269881']
:3D_Smiles:[size=4] :3D_Smiles:[/size]
[/quote]
vurike mama ...chiraku 10gi edo comedy ga post chesina ..... sSc_hidingsofa sSc_hidingsofa H&*()

Posted

[quote name='Silver_mani' timestamp='1360729825' post='1303269885']
vurike mama ...chiraku 10gi edo comedy ga post chesina ..... sSc_hidingsofa sSc_hidingsofa H&*()
[/quote]
[img]https://lh4.googleusercontent.com/-FFOOSG67qBg/TqOWdxWNHXI/AAAAAAAAIZM/SPo9Gh3KQmw/s150/Brahmi-1.gif[/img]

Posted

[quote name='Manthrii' timestamp='1360729879' post='1303269891']
[img]https://lh4.googleusercontent.com/-FFOOSG67qBg/TqOWdxWNHXI/AAAAAAAAIZM/SPo9Gh3KQmw/s150/Brahmi-1.gif[/img]
[/quote]
mana sambadu ki clear ga explain chey ...nenu chepte artham kavatle [img]https://lh4.googleusercontent.com/-FFOOSG67qBg/TqOWdxWNHXI/AAAAAAAAIZM/SPo9Gh3KQmw/s150/Brahmi-1.gif[/img]

Posted

[quote name='Silver_mani' timestamp='1360729929' post='1303269894']
mana sambadu ki clear ga explain chey ...nenu chepte artham kavatle [img]https://lh4.googleusercontent.com/-FFOOSG67qBg/TqOWdxWNHXI/AAAAAAAAIZM/SPo9Gh3KQmw/s150/Brahmi-1.gif[/img]
[/quote]

[img]https://lh5.googleusercontent.com/-XfoDFr_g1fY/TWhSW5UJ0qI/AAAAAAAAIZY/BoMo6d3C6og/s150/brahmi.gif[/img] cheptha mama..

Posted

[quote name='Silver_mani' timestamp='1360728669' post='1303269821']
Assume u broke the data into multipe batches ... Send each batch throuch 1 link , then do the follwing
sum of amounts = agrregation of all the rows in a column
total item count = no of rows processed ( you can ccalculate this using a DS utility (predefined one )
[/quote]

kk le mama repu chustanu..thanx for the input

Posted

[quote name='Manthrii' timestamp='1360729554' post='1303269869']
detail records and header records saparate ga generate cheyye... header create cheyyatanki aggregator use chesa, fixed length annav kabati column names same ichela cheskoni funnel pettukunna.. next sort
[/quote]

cool baa..nuvu incomind data ni two streams ga split chesi...oka stream lo unna data ni aggreagate chesava? to generate the header record?

if soo..in my case...total_amount kavali ante...aggregator stage lo calcualtion option slect chestamu...adhee naaku total_item_count kuda kavali...so daniki inkoo aggregator stage use cheyali aa ..leka same aggegator stage lo nee both sum of amounts and count of items cheyachu aa??

if possible nuvvu follow ayna pproach cheptava baa

Posted

[quote name='arey ooo samba' timestamp='1360730431' post='1303269919']
cool baa..nuvu incomind data ni two streams ga split chesi...oka stream lo unna data ni aggreagate chesava? to generate the header record?

if soo..in my case...total_amount kavali ante...aggregator stage lo calcualtion option slect chestamu...adhee naaku total_item_count kuda kavali...so daniki inkoo aggregator stage use cheyali aa ..leka same aggegator stage lo nee both sum of amounts and count of items cheyachu aa??

if possible nuvvu follow ayna pproach cheptava baa
[/quote]
same aggegator lo nenu detail record count and amount sum calculate chesanu. next detail records ki saparate link nundi theskunna,
[size=4]header ki detail records ki same metadata vache la chuskunna mama. ne case lo hdr and detail records lo names edhaina common ga undevi unte dhani paina sort chesthe sarippothundhe[/size]

Posted

[quote name='Manthrii' timestamp='1360730635' post='1303269935']
same aggegator lo nenu detail record count and amount sum calculate chesanu. next detail records ki saparate link nundi theskunna,
[size=4]header ki detail records ki same metadata vache la chuskunna mama. ne case lo hdr and detail records lo names edhaina common ga undevi unte dhani paina sort chesthe sarippothundhe[/size]
[/quote]

kk baa..will look into it tomorrow...thanx

  • Upvote 1
Posted

sambadu ... record count vishayam lo inka doubt ga vunda ? [img]https://lh4.googleusercontent.com/-FFOOSG67qBg/TqOWdxWNHXI/AAAAAAAAIZM/SPo9Gh3KQmw/s150/Brahmi-1.gif[/img]

Posted

[quote name='Silver_mani' timestamp='1360731105' post='1303269974']
sambadu ... record count vishayam lo inka doubt ga vunda ? [img]https://lh4.googleusercontent.com/-FFOOSG67qBg/TqOWdxWNHXI/AAAAAAAAIZM/SPo9Gh3KQmw/s150/Brahmi-1.gif[/img]
[/quote]
adhi aggregator lo cheyyochu baa transformer lo oka extra coloum cheyyee.. 1 ani ivvu default value

aggregator lo add cheyyii anni 1s add ayye count ichidhi

Posted

samba repu chupistha kavalante design. ardham kakunte cheppu

goodnight

Posted

[quote name='Manthrii' timestamp='1360732456' post='1303270022']
adhi aggregator lo cheyyochu baa transformer lo oka extra coloum cheyyee.. 1 ani ivvu default value

aggregator lo add cheyyii anni 1s add ayye count ichidhi
[/quote]
telsu mama .....nuv ala kakunda kuda calculate cheyyochu ... without aggregator

×
×
  • Create New...