1

In IBM DataStage, we have a connection that involves a Sequence File Connector, a Filter, and a DB2 Lookup stage. Is it possible to perform a DB2 Lookup with information from the Filter stage? For example, if the Filter stage has two records of (age="8") and (age="9"), can we use this information to execute an SQL query on the DB2 connector and retrieve records that satisfy the conditions (age="8") and (age="9")?

william007
  • 17,375
  • 25
  • 118
  • 194

1 Answers1

1

Yes - it is called a sparse lookup

The advantage is that the information from the "stream" is used to specifically wquery the database. On the other hand this could be slow if you are processing many rows - so be thoughtful about this functionality.

MichaelTiefenbacher
  • 3,805
  • 2
  • 11
  • 17