Please rephrase the question. I do not understand it. You may want to ask a collegae to help with that as they probably know some more context and can help making the question more clear for readers with null context.
Hi @Heinvandenheuvel , 1.we migrate data sap to snoflake we facing issue 'null value in not null column' during cdc . 2.we use some global rule. 3.our need find, which column get into null issue? 4.we don't have access both source and target. 5.so i ask is possible to see not null column details in qlik replicate?
IMHO it is very poor, unsustainable, practice for Replicate support folks not to have access to the source and/or target. They have to be able to trust you. In your position you can just syphon of all data to a database of file set under your control.
Anyway -
Null value are often the result of invalid transformations, often involving dates.
You could try
target endpoint - internal parameter - keepCSVFiles - Next study the CSV files corresponding with a target error searching for null colums
create a test tasks with alternative target, let replicate create the target table, now modify the target table to allow null on all non-null columns; let it run for a while; select count(*) from <table> where <non-null-column> is null to find which column(s) is/are responsible. May want to use other selects on those columns (top 10) to see what the data likely should look like, and for full resolution select the PK from target with null values, and select corresponding columns on source for that key
