01: Getting StartedExtract the Data 02: Extract the Data to be PrivatizedCreate Database Objects 03: Create Database ObjectsBasic Masking Techniques (Convert) 04: Use Basic Masking TechniquesUse Compare to Validate Your Changes 05: Use Compare to Validate Your ChangesPopulate the Destination Tables 06: Insert and Load the Destination TablesRetry or Restart an Optim Process Edit and …
Hi , Some of our customers using Checkpoint VPN through browser. It’s an old technology but there are companies that still using it. With PC’s you can easily use java applets via Internet Explorer but if you using Mac you need a firefox browser and not an updated one. Firefox not supporting java applets after …
Hi , When you develop an ETL job on DataStage if your connection got lost your session may not close. And you try to re-open your job probably you will get an error like this ; To handle this error we need to disconnect the session. First we need to get in IIS Console with …
Hi All , Today one of our clients has a problem with starting DataStage Designer. As the message says there is an error on proxy.xml file. Old proxy file ; New and proper proxy.xml file While I checking installation path I saw there are two different installations , so I assume in first installation there …
DataStage Error: Failed To Load The Java Virtual Machine Read More »
Hi , When you install information server on a host if you don’t have any certification you may get an error like this ; ” This page requires a secure connection which includes server authentication. The Certificate Issuer for this site is untrusted or unknown. Do you wish to proceed ? “ The solution is …
Hi , Recently two of our clients had same problem, time out error. When we try to import metadata of databases that we will investigate about personel data GDPR vise , we couldn’t import any tables. On a SQL Server via ODBC Connector ; CDIMR3801E Error Occurred when attempting to browse bridge or connector data …
IBM InfoSphere Metadata Asset Manager Timeout Error Read More »
Hi , At one of our customer we are using InfoSphere Optim to archive old records for GDPR. We create a parent-child hierarchy model of their database model.We will archive 3 million policy and connected other data about it. Today when we deleting archived data from database which is oracle 11.2 , we get error …
InfoSphere Optim Error: Client-Side OCI Error Id=OCI_NO_DATA Read More »
Partitioning ? In DataWarehouses and OLTP systems we use partitions for keeping data separately. In this way when we run a query database engine doesn’t need to scan all the table , it just accesses the partition that needs. Oracle defines its partitioning like this ; Partitioning is powerful functionality that allows tables, indexes, and …
Hi , One of our current projects we are developing a DataWarehouse. We already developed our ETL processes and reports , but it is time for deploy that in prepord environment . The first test set is contains check null control of all the columns in DWH and DM tables. And the second test is …
Testing DWH & DM Tables : Column Fullness And Daily Record Trend Read More »
Hi , I’ve been trying to install a virtual Windows Server 2016 in Virtualbox. My host is Windows 10 Pro for Workstation. I installed windows server2016 successfully, then i realized that I did not increase the number of CPU , I have AMD Ryzen 9 5900x so I can give 8/24 of Virtual Cores. When …
Windows In Virtualbox Does Not Start With More Then 1 CPU Read More »
