topic Re: null column deatails in Qlik Replicate

null column deatails

Titus — Thu, 07 Dec 2023 16:47:01 GMT

Hi team,

is it possible to view details of the 'source null' column in Qlik Replicate without having to view both the source and target?

Re: null column deatails

Heinvandenheuvel — Thu, 07 Dec 2023 18:53:07 GMT

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.

Hein

Re: null column deatails

Titus — Thu, 07 Dec 2023 20:45:30 GMT

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?

Re: null column deatails

Heinvandenheuvel — Thu, 07 Dec 2023 21:52:58 GMT

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

Hein.