You can translate the question and the replies:

integrated view is giving Null output though it has values init.

Hi Team, I have created integrated view using 2 base views in denodo. When i execute it, only 1st row i can see. Rest of the rows, i am seeing null values. It is the same case with many integrated views we created in denodo, we get all null valued rows except the 1st row. Please let us know what parameter we need to change to view the output that matches with SQL developer output data. Best Regards, Subhash.
user
07-03-2019 06:54:04 -0500

1 Answer

Hi, I have created an integrated view and was able to get the results as expected. I would suggest you do the following checks in the Virtual DataPort Administration Tool: * Check the [data type compatibility](https://community.denodo.com/kb/view/document/VDP%20Conformance%20with%20Standard%20SQL?category=VQL) of the fields of the base views in case you have modified the data type while creating the views. * In case you have performed the join operation, check the join conditions of the integrated view. If the issue still persists, and you have an active support account, you could open a [support ticket](https://support.denodo.com/). Hope this helps!
Denodo Team
08-03-2019 07:39:19 -0500
You must sign in to add an answer. If you do not have an account, you can register here