Data warehousing with Teradata
Friday, January 28, 2011
How many partions in given SQL ?
Partition by CASE_N
( empSalary < 10000,
empSalary < 20000,
empSalary < 300000
empSalary < 4000000,
NO CASE OR UNKNOWN)
)
Ans: 5 Partitions
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment