RankingTheRecordProblem

[admin]

 
-----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

[admin]

-----Original Message-----
From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de]
Sent: Wednesday, October 15, 2003 8:08 AM
To: datastage-users@oliver.com
Subject: RE: RankingTheRecordProblem


Hello Nibha,

this is a very standard problem, which you can learn in Lesson 4 of any
DataStage Course for Beginners.

In the Stage you make first a Lookup on your table if the record is there,
then you have two links one insert and one update, you set the relevant
constraint and here you are. If you look in your logfile /Monitor you see
then the number of records updated and the number of records inserted.

For the grouping of Records you can take the aggregator before a transform.

Wolfgang

-----Original Message-----
From: Nibha Nanda [mailto:Nibha_Nanda@tcscal.co.in]
Sent: Wednesday, October 15, 2003 2:25 PM
To: datastage-users@oliver.com
Cc: Babatunde.Ebohon@target.com
Subject: RankingTheRecordProblem


hello,
I am working in data stage & facing this problem . When I am inserting my
record in a table I want the record to be updated if it is aready present Or
inserted if absent & I want to know the count of the number of records
inserted & updated sepatrately. Also in a table while I am grouping the
record I want to take first 3 or 4 record based on some sorting & then do
some transformation on it. If some body can help me please reply

Thanks & Regards,
Nibha Nanda.
Tata Consultancy Services
Plot- B1, Block-EP, Sector-V
Salt Lake Electronics Complex
Kolkata 700 091
INDIA
Ph: 91 33 23339309
Extn: 9309