RankingTheRecordProblem
Posted: Thu Nov 13, 2003 12:00 pm
-----Original Message-----From: Nibha Nanda=20
[mailto:Nibha_Nanda@tcscal.co.in]Sent: Wednesday, October 15, =
2003=20
7:25 AMTo: datastage-users@oliver.comCc:=20
Babatunde.Ebohon@target.comSubject:=20
RankingTheRecordProblem
hello, I am working in data =
stage &=20
facing this problem . When I am inserting my record in a table I want =
the record=20
to be updated if it is aready present Or inserted if absent & I want =
to know=20
the count of the number of records inserted & updated sepatrately. =
Also in a=20
table while I am grouping the record I want to take first 3 or 4 =
record=20
based on some sorting & then do some transformation on it. If =
some=20
body can help me please reply
Thanks & Regards,Nibha =
Nanda.Tata=20
Consultancy ServicesPlot- B1, Block-EP, Sector-VSalt Lake =
Electronics=20
ComplexKolkata 700 091
INDIAPh: 91 33 =
23339309 Extn:=20
9309
-----Original Message-----From: Nibha Nanda=20
[mailto:Nibha_Nanda@tcscal.co.in]Sent: Wednesday, October 15, =
2003=20
7:25 AMTo: datastage-users@oliver.comCc:=20
Babatunde.Ebohon@target.comSubject:=20
RankingTheRecordProblem
hello, I am working in data =
stage &=20
facing this problem . When I am inserting my record in a table I want =
the record=20
to be updated if it is aready present Or inserted if absent & I want =
to know=20
the count of the number of records inserted & updated sepatrately. =
Also in a=20
table while I am grouping the record I want to take first 3 or 4 =
record=20
based on some sorting & then do some transformation on it. If =
some=20
body can help me please reply
Thanks & Regards,Nibha =
Nanda.Tata=20
Consultancy ServicesPlot- B1, Block-EP, Sector-VSalt Lake =
Electronics=20
ComplexKolkata 700 091
INDIAPh: 91 33 =
23339309 Extn:=20
9309