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 »
This is a usefull query for active sessions to kill ; You can find more queries like this at the link below ; https://ittutorial.org/oracle-dba-scripts-all-in-one-3-blocking-sessions-and-lock-kill-scripts/
When I does my research about Data Warehousing and Big Data , I found some course notes of Dr. Andreas Geppert from University of Zurich. They are really great and easy to understand. If you are new at data warehousing I strongly recommend to check them out. Part 1 ; [flipbook pdf=”https://techbros.com.tr/wp-content/uploads/2020/03/dwh-01.pdf”] https://www.ifi.uzh.ch/dbtg/teaching/courses/DataWarehousing/Unterlagen/dwh-01.pdf Part 2 …
Hi ! In this case I need to truncate a partition but I don’t know it’s name. This table has a range partition for every month , so I know HIGH_VALUE of particular partition. We can find partition_name in ALL_TAB_PARTITIONS table but HIGH_VALUE column has CLOB data type. We need a script like below for to change …
Stored Procedure : Truncate Partitions By HIGH_VALUE Read More »
