| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: what is the mean of Try to have the constraints in the 'Selection' criteria of the jobs itself. This will eliminate the unnecessary records even getting in before joins are made?
|
| November 11, 2005 05:22:52 |
#1 |
| dimple |
Member Since: Visitor Total Comments: N/A |
RE: what is the mean of Try to have the constraints in...
|
| It probably means that u can put the selection criterai in the where clause,i.e whatever data u need to filter ,filter it out inthe SQL ,rather than carrying it forward and then filtering it out. |
| |
Back To Question | |
