Interested to Buy Any Domain ? << Click Here >> for more details...
What is a range lookup?
- 2 Answers
- 7622 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bharathram1234
range lookup is the stage used to return a new column having the range from-to..
In that in reference u give
rng_from rng_to ret_value
1 99 A
100 199 B
.. .. ..
and master
give range as the other column
and map to range of master...
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / guest
With range lookup , lookup can be performed such that column
from reference field lies within a set values(columns) in
the stream link rather than just joining on a exact match
| Is This Answer Correct ? | 2 Yes | 3 No |
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are data elements?
What are the types of containers and how to create them?
What is the difference between lookup and sparse lookup?
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
how many rows sorted in sort stage by default in server jobs
How to initialize environment variables?
How a server job can be converted to a parallel job?
what is advantages of snowflake when it is used?
What is the difference between odbc and drs stage?
What are the different layers in the information server architecture?
How many Nodes configuration file you used in your last project?
Teradata 
