How to achieve not(notfound()) results in parallel

vijaydev · Post by **vijaydev** » Mon Oct 13, 2008 7:14 am

Hi,

I am new to datastage parallel, please let me know how to achive not(notfound(....)) results in parallel edition.

my requirement is i need to pass only new records which is not present in target.

Thanks in Advance

-Vijay

ArndW · Post by **ArndW** » Mon Oct 13, 2008 7:23 am

Is this regarding lookup stage results?

vijaydev · Post by **vijaydev** » Mon Oct 13, 2008 7:30 am

I dont know which one is suitable for me weather its lookup or change capture stage.

My requirement is i need to inset the records which is not avaialable in target.

- Vijay

ray.wurlod · Post by **ray.wurlod** » Mon Oct 13, 2008 3:42 pm

The Lookup stage has a "lookup failed" rule - you program it as you require. If you want to continue processing the stream input row where lookup failed, you set the rule to "Continue" and test a lookup key column for being null. The change detection stage types allow you to set a code value for the situation you describe; that the key exists in the "before" or "first" data set but not in the "after" or "second" data set.