InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
The Use Of The Where 1=1 Is Something That Will Be Good For Mapping Fields In The Future Or Is Possible That Qlikview Will Determine That Where 1=1 Will Allow Optimization? |
|
Answer» GOOD question. We use WHERE 1=1 to force the un-OPTIMIZED load required by MAPPING LOAD. I’m hopeful that if Qlikview were changed to CONSIDER 1=1 as an optimized load, they will also recognize that MAPPING LOAD should be non-optimized. Good question. We use WHERE 1=1 to force the un-optimized load required by MAPPING LOAD. I’m hopeful that if Qlikview were changed to consider 1=1 as an optimized load, they will also recognize that MAPPING LOAD should be non-optimized. |
|