Data Stage - Lookup vs. Join Stages
The Lookup stage is most appropriate when the reference data for all lookup stages in a job is small enough to fit into available physical memory. Each lookup reference requires a contiguous block of physical memory. If the datasets are larger than available resources, the JOIN or MERGE stage should be used.
If the reference to a Lookup is directly from a Oracle table, and the number of input rows is significantly smaller (eg. 1:100 or more) than the number of reference rows, a Sparse Lookup may be appropriate.
Readers who viewed this page, also viewed:
- How to Troubleshoot Database Errors Caused by Deleting Repositories using Siebel Tools (42.9%)
- Tracing Siebel server task with SQL Trace and TKPROF in Oracle (42.9%)
- Duplicate Records after Export in Siebel (42.9%)
- EIM Data Loading : Oracle function - Bulk Collect (42.9%)
- Table Lock in Oracle (42.9%)
- Siebel session hints (42.9%)
- What is sfsutl, How Should SFSUTL.EXE be Used? (28.6%)
- Oracle CRM OnDemand releases Version 20 (28.6%)
- Oracle's Siebel CRM is in the Leaders Quadrant and Oracle Fusion Sales in the Visionaries Quadrant of Gartner 2012 report (28.6%)
- Handling Performance issues during CheckIn / CheckOut Process (28.6%)