全部博文(69)
发布时间:2015-12-31 07:19:19
In db2, null could be anything. But some time when we join tables by using join condition which involves null values, we should remember that :a.cola = b.colb -- if both are null, the condition is false, that is null = null returns false.a.cola <> b.colb -- if both ar.........【阅读全文】
发布时间:2015-10-06 07:54:32
create table edw_tester_bcsc.role_player_to_registration_rlship_pd_bak<br />as<br />(select * from edw_core_bcsc.role_player_to_registration_rlship) <br /> data initially deferred refresh deferred;<br />refresh table edw_tester_bcsc.role_player_to_registration_rlship_pd_bak;.........【阅读全文】
发布时间:2015-09-03 04:40:47
Many data warehouses do not use any change-capture techniques as part of the extraction process. Instead, entire tables from the source systems are extracted to the data warehouse or staging area, and these tables are compared with a previous extract from the source system to identify the changed da.........【阅读全文】
发布时间:2015-08-22 14:46:59
http://www.vixual.net/blog/archives/178
......【阅读全文】