Question & Answer
Question
When performing a sparse or normal lookup in a parallel job how do you return multiple rows?
Answer
For a sparse lookup all matching rows are returned by default. There is no way to change this and any rows matching the key values will be returned.
For a normal lookup you will need to specify this option:
- Right click the lookup stage and click Properties then click the Constraints icon
- Select the drop-down list called "return multiple rows from link"
- This list will give you all reference links but only one can be used to return multiple rows.
[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.1;8.0;7.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
23 June 2018
UID
swg21413260