What is a range lookup?
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 |
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
What are data elements?
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
What is a folder? Difference types of stages?
What is the use of datastage director?
What is the default padding character?
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
how can i abort the job if i get more than 100 errors in job log?
how to cleansing data
What is the difference between in process and inter process?