DSXchange

I have Main date field in Main stream of the lookup and I have Begin_DT and END_DT field in reference table.
How do I do range lookup based on the these date field (Begin_DT < Main_Dt < END_DT)?
Range lookup options in the stage gives me only Main stream fields for the Begin and End value.

Let me know, if there is a option?

Let me know, if I did not make the questions clear.

You can do a range lookup on either the reference input or on the stream input. Examine the examples in the Knowledge Center or in the Parallel Job Developer's Guide.