Interested to Buy Any Domain ? << Click Here >> for more details...
when we will use connected Lookup & Unconnected Lookup
- 3 Answers
- 11321 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / jayanthi
In Datastage, the same can be expalained as Normal
(Connected)Lookup and Sparse(unconnected) lookup.
For sparse lookup
When the refrence data volume is huge and primary volume is
very less,you can pass the input records key columns to
match against reference in refrence table extraction query
where clause.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How do you import and export data into datastage?
Differentiate between Join, Merge and Lookup stage?
Define Routines and their types?
Describe link sort?
EXPLAIN SCD
Define Merge?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the difference between in process and inter process?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are routines in datastage?
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)
Define meta stage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Define data aggregation?
