Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
attunitysupportcs
Partner - Contributor III
Partner - Contributor III

Replicate LOB column ( Log Stream)

If we set the Log stream staging task to replicate LOB column but do not set the replicate LOB column for the replication task will it affect the data sync issue?

For example,

Logstream staging task enable to replicate LOB column at the task setting

Replication task 

Source: ibm db2 for iseries

Target: Microsoft Azure SQL Database

Do not enable to replicate LOB column at the task setting.

 

Thanks

Labels (1)
1 Solution

Accepted Solutions
shashi_holla
Support
Support

As @OritA mentioned, there will be no data discrepancy other than LOB columns not being replicated to the target. If you need LOB columns on the Target: Microsoft Azure SQL Database then have to enable LOB else can ignore it.

View solution in original post

2 Replies
OritA
Support
Support

Hi, 

In general if a task is not set to replicate LOB columns than these columns will not be replicated to the target.
When working with Log Stream, if you would like to Replicate the LOB columns to any of the targets than you have to enable LOB replication at the  Log Stream staging task. In the Log Stream remote task you can decide wheter you would like to Replicate LOBs or not. 

Regards,

Orit 

shashi_holla
Support
Support

As @OritA mentioned, there will be no data discrepancy other than LOB columns not being replicated to the target. If you need LOB columns on the Target: Microsoft Azure SQL Database then have to enable LOB else can ignore it.