Pagine

▼
giovedì 7 gennaio 2021

Unable to visualize the Month name in BI Publisher

›
 I have been asked to display the dates in a BI Publisher extract in the following format:  DD-Mon-YY - I.e. 20-Jul-19 I thought it was jus...
lunedì 30 ottobre 2017

[Oracle Tips] Looping over dates in PL/SQL

›
How do you loop over dates if you want to build your own calendar? I had to generate a weekly calendar that had every week starting on the...
mercoledì 23 agosto 2017

[Oracle Tips] Changing Default End Date in SCD KM

›
ODI has an IKM for Loading SCD Type 2 dimensions. The IKM is ' IKM Oracle Slowly Changing Dimension '. The default value for Slow C...
martedì 22 agosto 2017

[Oracle Tips] Looking for a value in all table columns of a database schema

›
I have been working on a project where honestly I did not have much knowledge of the data model of the schema I was using. Most of the times...
mercoledì 31 maggio 2017

ODI Tips: ODI initialization hangs

›
I have been on the same OBIA/ODI project for almost two years now and every now and then I get this issue. ODI Studio hangs on ODI initiali...
giovedì 26 gennaio 2017

Oracle Tip: recovering SQL Developer passwords

›
I must admit that I am quite lazy (and not a very tidy person either). When I am given a new database connection to work with, I configure i...
mercoledì 18 gennaio 2017

ODI Tip: Get Physical Schema from Logical Schema in an ODI variable

›
When it comes to file paths you do not want to hard-code them because they will need to be manually updated when you migrate from one enviro...