Implementing Business logic in views is something seen quite often. Actually a view in my experience often contains some sort of data enrichment, -enhancement or -extension. So I am surely not the first one to come across the thought of adding some nifty tricks to a view. Well, tonight it seems I got too creative. […]
Tag: Teradata
Subtle differences in Teradata and SQL Server
Imagine the hair pulling experience, when you port knowledge from one RDBMS to another, and it just doesn’t work. I had one such experience today, when I had to generate a certain filter for at Query. I wanted to combine the year and month value, to filter on the unique month key which consisted of […]
How to do a String REPLACE in Teradata
String Replace does not exist but can be accomplished with the following procedure: INSTALL REQUIREMENTS:– 1) GRANT ALL ON “%TDUser%” TO “%TDUser%” WITH GRANT OPTION 2) C++ compiler, if running the TD Demo How to replace “old” with “new” so that ‘Hello, old world’ becomes ‘Hello, new world’ 1) Logon to teradata using the %TDUser% […]
Teradata based Data Source Views in Analysis Services
Now here’s a catch. I was trying all night long to figure out why Visual Studio was hanging on me, every time I wanted to add a Teradata based relational data source. Turns out that the list of available objects gets populated with all the objects in the current server, regardles of permissions. So connecting […]