DSXchange

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

Is this regarding lookup stage results?

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

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.