Answer Posted / 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 |
Post New Answer View All Answers
Define orabulk and bcp stages?
what is the use of materialized view?
What are the functionalities of link partitioner?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are orabulk and bcp stages?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
I have a few records just I want to store data in to targets cycling way how?
State the difference between an operational datastage and a data warehouse?
How a routine is called in datastage job?
What is the difference between orabulk and bcp stages?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are stage variables, derivations and constants?