DSXchange

You are right. I thought the requiremnt will be with two groups. If group no is increasing then we need a count variable.

Capture the delete change code records into a dataset. in the next job do look up with source and delete from target.

stuartjvnorton wrote:I hate "requirements" based on trivial examples.
What happens if you have a 4th record

It will work with N no of rows. Try it out.

Your job esign would be: seqfile-> sort1-> sort2-> tsfr-> target logic would be: Sort1- Sort on ph no with Key change col=True--Asc Sort2- Sort on Ke change col, ph no-asc Tsfr- Create stgv1 stggroup, Stgv2 Stgfamily, Stgv3 stgprev(Default=1) stggroup= If keyChange =1 And Stgprev =1 Then 2 Else 1 St...

yes. Problem might be with Configuration file. Try with another config file or change the no of nodes in the same config file.

Yes.. By using Merge stage we can perform inner join and left outer join

All the detail records will be having same index, header and trailer will be having different index
like
11|25/01/2011
22|A|123|434
22|B|345|567
-
-
22|H|545|858
99|9(record count)
so while extracting the data from source u can extract only the records which are starting with 22

post clear query

Hi pandeeswaran
We can edit the configuration file..
I saw it in 8 think same in 7 also

The default configuration file is default.apt, with one node this you can see by going to Tools, Configurations in datastage designer, there select default.apt configuration file .. so you can see the configuration file.. if you want to create own configuration file, just copy the code what is there...

sort key column in ascending mode and timestamp in descending then use Header stage and there give only one row to send out put..
so obviously you will be getting only 1st row at the target

If key column datatype is text then we use Hash
if key column datatype numeric we use modulous
if one key column numeric and another text then also we use Hash
if both key columns numeric then we use Modulous.

because modulous can be performed only on numbers

First sort the data
then use aggregator and perform group count, then use filterstage and send the records which contains count >1 to alink and count=1 to another link

try this

Hi Ray
Thank you for your reply and extremely sorry for the mistake it is DRS connector stage not ORS connector is it there in DS 8.1 version

and

for 8.5 i saw in the net IBM 8.5 is

IBM Infosphere information server 8.5 is it right ?
if not what it is?

Hi
DataStage 8.0.1 is
IBM Websphere Enterprise Edition DataStage & QualityStage

DatStage8.1 is
IBM Infosphere Enterprise Edition DataStage & QualityStage

like what is the expansion for DtaStage 8.5 version

is there DRS connector stage in 8.1

can any body tell?

thanks in advance