Vendor homepage https://www.allroundautomations.com/products/pl-sql-developer/Product help there is no online verson, but release notes https://www.allroundautomations.com/products/pl-sql-developer/release-notes/ Config
Continue ReadingBlog
Informatica PowerCenter Folder Naming
One way of naming folders in infa: SE_C1_COMMON_SOR – Ingestion area, system of record SE_C3_COMMON_CDW – Warehouse load area SE_C1_[Source Name]_SOR – Ingestion area, system of record for particular source system SE_C3_EDW_[Source Name] – Warehouse load as target from particular source system SE_M_[Source Name] – Data mart load from particular source system via DWH Alternative: […]
Continue ReadingNew Release of Enterprise Architect v16.0 (Build 1604) 21th of April 2022
There is a new release of this tool. Some key moments from release notes if you are working alone with this tool and doing data flows, data models. Full support of 64bits OS QEAX files – supports shared files with small workgroups A lot of improvements to diagramming It supports Python! Improved Code Engineering to […]
Continue Reading2022 Sale of Books and Videos at Packt for 5 USD
On 2022, for next 4 days, all books and videos are on sale and priced at 5 USD. That is awesome price, check here https://www.packtpub.com
Continue ReadingTemplate for requesting FTP connection details
This weekend our company migrated to another infrastructure provider and we are having issues connecting to your FTP site at xyz.com (111.111.11.11). Our external IP address is 22.22.22.222. Could you please provide these data in order for us to successfully connect: If you have whitelisting, please allow traffic from XYZ company’s public IP 22.22.22.222 In […]
Continue ReadingNew Release of Enterprise Architect v15.2 (Build 1560) 5th of November 2021
There is a new release of this tool. However, by checking release notes, seems no improvements or updates if you are working alone with this tool and doing data flows, data models. Seems no improvement to usability, bug fixing. Below the list from vendor’s site: The XML Import dialog now includes an option to either […]
Continue ReadingPyCharm 2021.1 Is Out
General overview video of new things PyCharm 2021.1 Is Out! | The PyCharm Blog (jetbrains.com). What’s new in more details What’s New in PyCharm 2021.1 (jetbrains.com) and detailed release notes PyCharm 2021.1 Release Notes – PyCharm – Confluence (jetbrains.com)
Continue Reading
Default Informatica PowerCenter Directories in Infa_Shared
I’ve had difficult time to find “vanilla” list of directories, so storing here as a reference. Informatica PowerCenter 10.0.
Continue Reading
Asmeninis komandiruočių logas
Kadangi esu turėjęs daug ir dažnai komandiruočių, susigalvojau sistemą kaip jas sekti. Kelis kartus labai pasiteisino, kai net po 2 metų, teko pateikti duomenis auditui ar mokesčiams. Yra dvi dalys: Excel failas ir katalogai. Pradėsiu nuo katalogų – reikia susikurti dviejų lygių katalogus. Pirmas pagal metus, antras su pirmos komandiruotės dienos data. Excelyje suvesdavau visą […]
Continue ReadingDate in ISO8601 Format in Oracle DB
Below the code example how to get date format as ISO8601. First example is current time zone. Second example is valid if your database is actually in UTC time zone. SELECT to_char(SYSTIMESTAMP, ‘YYYY-MM-DD”T”HH24:MI:SS.FF6TZH:TZM’) AS ISO8601 FROM dual; SELECT to_char(SYSTIMESTAMP, ‘YYYY-MM-DD”T”HH24:MI:SS.FF6″Z”‘) AS ISO8601_UTC_format FROM dual;
Continue Reading