Friday, January 28, 2011

How many partions in given SQL?

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