Answer Posted / 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 |
Post New Answer View All Answers
What are orabulk and bcp stages?
Give an idea of system variables.
What are the some differences between 7.x and 8.x version of datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Where the datastage stored his repository?
What are the different kinds of views available in a datastage director?
What is a datastage job?
Name the different sorting methods in datastage.
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How rejected rows are managed in datastage?
How do u convert the columns to rows in datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are transforms and what is the differenece between routines and transforms?
Explain the importance of surrogate key in data warehousing?
