Assume SQL,
Partition by CASE_N
( empSalary < 10000,
empSalary < 20000,
empSalary < 300000
empSalary < 4000000,
NO CASE, UNKNOWN)
)
teradata creates 6 partitions....
If value is not NULL and first 4 cases are not satisfied then data goes
to "NO CASE" partition
and NULL values goes to UNKNOWN partition
No comments:
Post a Comment