Interested to Buy Any Domain ? << Click Here >> for more details...
when we will use connected Lookup & Unconnected Lookup
- 3 Answers
- 11139 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?
What are constraints and derivations?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Where the datastage stored his repository?
What are stage variables and constants?
what is use of SDR function?
How we can covert server job to a parallel job?
Describe the main features of datastage?
How to convert RGB Value to Hexadecimal values in datastage?
how to delete one row in target dataset
How complex jobs are implemented in datstage to improve performance?
What is datastage engine?
Different ways a project can be moved to production ?...example ….export-import and Version control.
How to reverse the string using unix?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
