Select Change table header column should be removed from delta file

[TTH1]

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 

[john_wang · Accepted solution]

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.

[MoeE]

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

[john_wang]

Hello Mohammed @MoeE ,

Just to make sure the metadata is aligned.

Regards,

John.

[MoeE]

Hi John, 

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

Regards,

Mohammed