Aqua Data Studio 15.0.0-dev-68
Database:Teradata Aster
1.Connect Teradata Aster
Open Query Analyzer and execute the following scripts
CREATE SCHEMA "TeradataAster"
GO
CREATE FACT TABLE "TeradataAster"."clicks" (
"userid" integer NULL,
"pageid" varchar(30) NOT NULL DEFAULT 4001,
"ts" timestamp without time zone NOT NULL DEFAULT '2013-11-22 00:00:00'::timestamp without time zone
)
DISTRIBUTE BY HASH ("userid")
STORAGE COLUMN
COMPRESS MEDIUM
GO
CREATE DIMENSION TABLE "TeradataAster"."clicks1" (
"userid1" integer NULL,
"pageid2" varchar(30) NOT NULL DEFAULT 4001,
"ts3" timestamp without time zone NOT NULL DEFAULT '2013-11-22 00:00:00'::timestamp without time zone
)
DISTRIBUTE BY REPLICATION
STORAGE ROW
GO
CREATE DIMENSION TABLE "TeradataAster"."collegedepartments" (
"departmentid" integer NULL,
"departmentleadid" smallint NOT NULL DEFAULT 501,
"departmentheadid" integer NOT NULL DEFAULT 601,
"managerid" bigint NOT NULL DEFAULT 701,
"sectionid" integer NOT NULL DEFAULT 5001
)
DISTRIBUTE BY HASH ("departmentid")
STORAGE ROW
COMPRESS LOW
GO
Three tables get created in "TeradataAster" schema
2.In tree node expand Tearadata Aster database Server
Select Databases node,expand it
Go to Table node then select any two tables
In my case I have selected "clicks" and "clicks1" table,right click and select Compare option
Compare result get opened,in result "DISTRIBUTE BY" "STORAGE" clauses are common
in both tables but it's display in purple color as "Changed" part
3.Again go to Tables node then select any two tables
In my case I have selected "clicks1" and "collegedepartments" table,right click and select Compare option
Compare result get opened,in result CREATE DIMENSION TABLE "TeradataAster" clauses are common
in both tables but it's display in purple color as "Changed" part
so it should not display in purple color because that clauses are common in both tables
please go through screenshot(same_table.jpg)
