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 »
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 …
This is a usefull query for active sessions to kill ; You can find more queries like this at the link below ;
IBM Optim ile veri arşivlemede kullanılacak bir Archive Request oluşturmak için aşağıdaki adımlar izlenebilir. 1- DB Alias: DB Alias Optim için bağlantı bilgilerini temsil etmektedir. Hangi DB ye hangi kullanıcı ve şifre ile bağlandığınızı DB Alias oluşturarak Optim e bildirirsiniz. Bunun için Optim Configuration’ı açıp Tasks sekmesinden Create/Update DB Alias butonunu tıklamak yeterli. Açılacak olan …
ODI is the one of the most common ETL tool , especially in Turkey. It is very user friendly , easy to learn , tons of docs at web and there are many other advantages. Some times when we make a technical analysis about our ETL processes. And we need to find an ODI scenario …
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 , While developing ETL processes with PL-SQL we use “drop-create” for loading data to temp tables. Before creating temp table, we need to drop if it is exists in the database. If you try directly drop the table, and the table did not exists yet , then you will get “ORA-00942: table or view does …
DataStage and QualityStage stages are grouped into the following logical sections: General objects Data Quality Stages Database connectors Development and Debug stages File stages Processing stages Real Time stages Restructure Stages Sequence activities Please refer to the list below for a description of the stages used in DataStage and QualityStage. We classified all stages in …
Sometimes you have lots of data but not enough space at your storage. And you need to check your tables sizes and tables spaces etc. I think it is easier use queries than use clients utilities. We can use system tables for control size, parallelism degree , compression level and more. I use this two …
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 »