I believe that you are looking for a way to view bit data of a view built on top of a SQL Server data source as 1/0. In general, Denodo interprets bit data types from the datasource as boolean i.e true/false.
To achieve your use case, I would do the following steps.
* Create a base view using the “Create from query” option in the Virtual DataPort Administration Tool/ Web Design Studio.
* Ensure that the SQL query is written using CAST function to convert the bit datatype as an integer.
* Once the view is executed, the results will be displayed as 1/0 instead of true/false.
You can refer to the [Creating Base Views from SQL Queries](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-sql-queries) section of the Virtual DataPort Administration Guide which explains the steps to be followed to create a base view from a query.
Hope this helps!