I have an input file with this format
Country Age Sex NO
German 23 M 1
German 24 M 1
German 29 F 1
English 21 M 2
English 20 F 2
Dutch 28 F 3
Dutch 30 F 3
NO changes when Country is different. I have a hashed file to be used for lookup having only the NO column. That is:
NO
1
2
In the lookup, if the NO from the input file matches that in the hashed file, it is sent to the reject file. In this case, the REJECT FILE would have this format:
The same input file MINUS this:
Dutch 28 F 3
Dutch 30 F 3
The target file would have this:
Dutch 28 F 3
Dutch 30 F 3
How do I specify the contraints? I did this:
The reject file: Not(IsNull(DSLink.NO) and I checked the other box to send others down the target file.
I think my mistake is in the contraints. Any ideas pls?
Thank you.
PS. Im doing the lookup on the NO
Lookup and target DB
Moderators: chulett, rschirm, roy
Lookup and target DB
Datastage is pretty interesting