Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ramya
use sparse lookup when reference database is huge i.e ratio
of input data and reference data is 1:100 or more
| Is This Answer Correct ? | 37 Yes | 7 No |
Post New Answer View All Answers
Difference between in process and inter process?
What is use Array size in 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.
How to clean the datastage repository?
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?
State the difference between an operational datastage and a data warehouse?
What are the processing stages?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is the method of removing duplicates, without the remove duplicate stage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are stage variables and constants?
What is the difference between datastage and datastage tx?
What are the types of containers?
What are the areas of application?
