Re: goldengate keycols

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/goldengate-keycols-tp9626p9633.html

Keycols designates columns that uniquely identify rows. So there is no point to include null columns in the column list.. I didn't test it but I think keycols will not help you in the case of having a list of null columns in the definition.
So what is the problem here? You have a table with lots of nulls. So what are going to do with it? Don't you have some not null columns, which may be used to identify the rows? Just put them in keycols and go ahead.
How much big is the table? If it is not so big, and if a full table scan doesn't take much time, then you may live with it.. Of course if the table is getting bigger and bigger everyday, then you need to think something for the future.. But in that case, you may change the database design.. You may think decomposing those always-null columns from the not-null columns and etc..