Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create multisite table HR.Employees_tbl1 as
- (
- select Emp_ID varchar(50),
- Emp_Date 'yyyy-mm-dd',
- Notes 'Varchar(200)
- ) with data PI (Emp_ID);
- collect stats on HR.Employees_tbl1 column (Emp_ID);
- create multisite table HR.Employees_tbl2 as
- (
- select Emp_ID varchar(50),
- Ref_Date 'yyyy-mm-dd',
- Ref_Source 'Decimal(18,0)
- ) with data PI (Emp_ID, Ref_Source);
- collect stats on HR.Employees_tbl2 column (Emp_ID, Ref_Date, Ref_Source);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement