What is range look up and how it is used in datastage.

Say I have 5 rows in a source table ‎and for each rows 10 rows matching in a lookup table and my range is for lookup is 9 to 99. what will be the row count in output table?

Questions by taruna.arya

Showing Answers 1 - 2 of 2 Answers

ramireddy

  • Oct 17th, 2014
 

You will get same no of records in the source even there are duplicates in look up data

  Was this answer useful?  Yes

barak

  • Nov 21st, 2014
 

that depends on , if you set up "more than one row match" you will get you "Cartesian Product"

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions