topic Re: Select Change table header column should be removed from delta file in Qlik Replicate

Select Change table header column should be removed from delta file

TTH1 — Fri, 16 Jun 2023 10:42:28 GMT

Hi All,

While creating in delta file I have turned on store changes processing after that I have uncheck the below option because I don't want this column in my output file

change_seq

change_oper

change_mask

............

But still this header is showing in file there would be no data. I dont want these column in my file

Please help me

Re: Select Change table header column should be removed from delta file

john_wang — Fri, 16 Jun 2023 15:32:44 GMT

Hello @TTH1 ,

Welcome to the community.

I'm not sure which target endpoint it is, in my test labs, Replicate works fine with the Oracle target, however please take note that the "Change Table Creation" options should set to "DROP and CREATE" if the store change table exist already, the sample screen:

BTW, the first 2 columns are the store change table primary key columns, remove them leads warnings in design stage:

In runtime stage got warning too:

All change tables will be created without a unique index. As a result if tables contain lob columns they will be dropped form the change tables.

it's recommended to keep the 2 columns, they are helpful while your apps consuming the table data.

Regards,

John.

Re: Select Change table header column should be removed from delta file

MoeE — Tue, 05 Sep 2023 23:29:45 GMT

Hi John,

Is there a particular reason as to why the "Change Table Creation" options should set to "DROP and CREATE" if the store change table exist already?

Kind regards,

Mohammed

Re: Select Change table header column should be removed from delta file

john_wang — Wed, 06 Sep 2023 00:54:19 GMT

Hello Mohammed @MoeE ,

Just to make sure the metadata is aligned.

Regards,

John.

Re: Select Change table header column should be removed from delta file

MoeE — Thu, 07 Sep 2023 01:45:32 GMT

Hi John,

Thank you. Can you please elaborate a little for me?

Regards,

Mohammed