Materialized View support

[sudhanshu17]

Does Materialized view support in Qlik replicate version 6 or 7 , if not then please provide details.

[sudhanshu17]

Please suggest where can we find concept of using MV in Attunity.

[anat]

• Materialized views are not supported.

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/SAP%20Sybase%20ASE/limitat...

u can double check again...

[anat]

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/Oracle/not_sup_data_types....

[sudhanshu17]

Hi, 

Thanks for the reply, i have gone through the document but i think this is for  SAP. 

1. Using SAP Sybase ASE as a source

I would require the detail for ORACLE source and target.

Thanks,

Sudhanshu

[Steve_Nguyen]

@sudhanshu17 

the doc i see is for Oracle : 

Using Oracle as a source

 

1. Non-supported data types

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/Oracle/not_sup_data_types....

[shashi_holla · Accepted solution]

Hi @sudhanshu17 

In general materialized view should work but not supported if materialized view is based on a ROWID column.

Generic Materialized views will be under tables and not views. 

Hope this helps.

Thank you,