HI Team, My base view has a date field which is in datatype text ( Varchar-50) and giving value '20190910172316' . I tried to convert the same to date by using " to_date('yyyyMMddhhmmss' , base_view.eff_dt ) as eff_dt " in derived view layer. it worke...
Answers:
1
Hi I am following the online tutorial and when executing a query on the web service on 'C003' I get an array come back however there is no data in the array. According to the online tutorial I should be seeing 2 records in the array. Any tips on how I...
Answers:
3
Is there a way to create the Base Views directly from erwin files or erwin xml files instead of creating the base views individually. We generally create base views connecting to a database where the datamodel of EDW is sitting, but is there a way to c...
Answers:
3
Is there something we can run to pull out the base views which have a different map from the default for both the searchmethod and the view, itself?
Answers:
1
Hi, I have a table with multiple rows and a single column called ID - it is aways 5 chars long ID 12345 23456 34567 I want to create a view with a single column output and a single row output that will concatentate all the values inserting a com...
Answers:
2
Hi, I just downloaded Denodo Express and started importing some sources. I was wondering how I shoould be using Denodo in my Company, for example, is it right to install denodo in a server and then let the developer connect to this server using their...
Answers:
1
Hi Team, Can anyone suggest me some links to understand denodo data catalog better? I had a good read about it few weeks before, but am not able to find the content now, when I searched Thanks for your help, Manju
Answers:
1
Hello, For the Denodo catalog, what is the recommended way for a user to share a query, is it possible via the web interface? to other data catalog users? can it be shared so that other catalog users can see updates after obtaining access to the s...
Answers:
1
Hi, I'm having an issue with a delimited file source. The file is actually a column from a big query wich contains a CLOB, that clob has the next format : parameter1:value1;parameter2:value2;parameter[n]:value[n]; ........ What i want is to convert ...
Answers:
2
We are using the get_view_columns() function to pull denodo interfaces and columns into the MicroStrategy warehouse catalog. We have run into an issue that if a transformation has had manual vql manipulation, the function fails to return all columns. ...
Answers:
1