Detecting New Rows

[endyl13]

Hi,

I'm new to DataStage.
I'm trying to detect the new records that coming from one data source.
I have file A with key DSA_ID. I have table B which consist all the records with unique key that exist in the system, the key is also DSA_ID.

I try to use transformer stage to do this, but the problem is that i have to have 2 outputs. The first one with Constraint
'TabelA.DSA_ID Matches LookUpHashedB.DSA_ID'
and the second output with 'Reject Row' ticked.

How can I do this with only one output? I've tried to do using constraint :
'TabelA.DSA_ID <> LookUpHashedB.DSA_ID'
but it didn't work.

DSA_ID data type is VarChar(6)

Thanks in advance...
Endy

 

[jlito]

Hi bro,

What you're doing is correct. You just need to have a lookup for those records which are already existing. But why do you only need one output? Can you explain your purpose of having only one output.

What do you want to happen in your target table? Do you need only those records that are new? Or you want also to have those records updated?

Cheers!

 

[endyl13]

Hi Jito,

I only want one output, which consist the new rows only.
I've only got the answer, by using the 'Link Variable - Output - Lookup.NOTFOUND' as the constraint for the table.

Thanks...