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

[dilkush]

[quote name='arey ooo samba' timestamp='1343241041' post='1302198644']


nice baa...but how to retain those duplicate rows?
[/quote]
reatin cheyyaala inthakie ee requirement cundaa leka interview lo evadaina aadigindaa......

Ikkada output ayina vaatini mallie aah mundhu vunna source tho compare cheyyi.....change capture stage vaadi......change mode lo explicit keys and values ani ichi......key column emo 'Name' ivvu.....change value emo 'date' ivvu........ appudu andhulo '3' output vachianvannie antey update ani chuupinchavannie.......inthaka mundhu miss ayinaey anukuntaa akdaa.........

naaku telisi remove duplicate stage & sort ki okatey o/p vuntadhi anukuntaa........so, direct gaa reject cheyyatam kudarahdu kaavochu

[pandemkodi]

to retain

sort stg lo createchangecolumn option vuntadi kada

[dilkush]

[quote name='pandemkodi' timestamp='1343246419' post='1302199389']
to retain

sort stg lo createchangecolumn option vuntadi kada
[/quote]
ooh...adhokatundaa..... ......eppudu use cheyyaledhu

[qwerty1204]

[quote name='pandemkodi' timestamp='1343246419' post='1302199389']
to retain

sort stg lo createchangecolumn option vuntadi kada
[/quote]

Create Cluster Key Change Column aa baa u r saying abt?

ela use cheyali aa option ni?

[pandemkodi]

[quote name='arey ooo samba' timestamp='1343252377' post='1302200196']

Create Cluster Key Change Column aa baa u r saying abt?

ela use cheyali aa option ni?
[/quote]
yeaha dey mama
daanni yes pettu oka col create avutadi daanlo ila vastadi

col1 co12 clustercol
1 ravi 1
1 ravi 0
1 ravi 0
2 rahul 1
2 rahul 0
3 son 1

ikkada col1 key anuko neeku value change inappudu 1 istadi malli adey value vastey 0 istadi
antey 1 tarvata 0 vuntey avanni duplicates annattu

[qwerty1204]

[quote name='pandemkodi' timestamp='1343258160' post='1302200800']
yeaha dey mama
daanni yes pettu oka col create avutadi daanlo ila vastadi

col1 co12 clustercol
1 ravi 1
1 ravi 0
1 ravi 0
2 rahul 1
2 rahul 0
3 son 1

ikkada col1 key anuko neeku value change inappudu 1 istadi malli adey value vastey 0 istadi
antey 1 tarvata 0 vuntey avanni duplicates annattu
[/quote]
got it baa

Create Key Change Column ani kuda okati undi ga baa..how is it diff from Create Cluster Key Change Column

[pandemkodi]

[quote name='arey ooo samba' timestamp='1343259301' post='1302200901']
got it baa

Create Key Change Column ani kuda okati undi ga baa..how is it diff from Create Cluster Key Change Column
[/quote]
adi edo minor diff naaku correct ga teledu baa

[pandemkodi]

lifted from Google

[color=#333333]create key change column generates while sorting the data..It generate one for first record and zero for rest of the records by group wise..[/color]

[color=#333333]cluster key column generates on sorted data when sort mode is donot sort..[/color]

[qwerty1204]

[quote name='pandemkodi' timestamp='1343259384' post='1302200908']
adi edo minor diff naaku correct ga teledu baa
[/quote]

asalu enni options etta use chesava baa...

[Silver_mani]

[quote name='pandemkodi' timestamp='1343258160' post='1302200800']
yeaha dey mama
daanni yes pettu oka col create avutadi daanlo ila vastadi

col1 co12 clustercol
1 ravi 1
1 ravi 0
1 ravi 0
2 rahul 1
2 rahul 0
3 son 1

ikkada col1 key anuko neeku value change inappudu 1 istadi malli adey value vastey 0 istadi
antey 1 tarvata 0 vuntey avanni duplicates annattu
[/quote]


GP baa

[dkchinnari]

[quote name='Dalapati' timestamp='1343248500' post='1302199702']
ooh...adhokatundaa..... ......eppudu use cheyyaledhu
[/quote]neeku asalu work unte kadhaaa....last 2 yrs em work sesavo seffu db ee kadhaa...linux anna nerchuko

[Terminator II]

[Silver_mani]

[quote name='vishwamithra' timestamp='1343272790' post='1302201810']
neeku asalu work unte kadhaaa....last 2 yrs em work sesavo seffu db ee kadhaa...linux anna nerchuko
[/quote]

[dkchinnari]

[quote name='Silver_mani' timestamp='1343273020' post='1302201827']

[/quote]

[Silver_mani]

[quote name='vishwamithra' timestamp='1343273095' post='1302201833']

[/quote]
maa dalafathi ki anni vachu