Hi All ! One of out projects we need to do apply time weighted average to aggregate sensor data. Simple explain of TWA ; Input data(quality=good) 12:00:00 – 10 12:00:02 – 12 12:00:05 – 15 “TimeAverage is a slopped line between all of the points in the interval – in this case …
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 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 , 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 , If you are an ETL Developer eventually you gonna need to use parameters. You can use it incremental loading or deploying the jobs dev to test or dev to prod. In this scenario , we will use this for deploying advantages. 1- Creating the parameter set ; In this ParameterSet we have 3 …
Hi everyone , As you know IBM Information Server works as client-server architecture. When you install client applications on your local computer , it needs to access some ports on server-side. So here is the list of ports that you need when you use the client apps; For more information; https://www.ibm.com/docs/en/iis/11.7?topic=computers-configuring-your-network
Merhaba , Bilginin güç getirdiğini keşfettiğimizde medeniyetimizi kurmaktaki ilk adımı atmış olduk. Bu durum hiç değişmedi hatta artarak günümüze geldi. Bugünün koşulları hala çağlar öncesi kadar vahşi. En doğru bilgiye en hızlı ulaşanın hayatta kalacağı bir endüstri savaşı var. Kurumların veriden bilgi edinmesi ömürlerini sürdürebilmeleri için elzem bir halde. Kobilerden en dev kurumlara kadar uyulması …
Veri ambarı projelerinde karşımıza çıkan sorunlar Read More »
Hi , You can set LDAP authentication on IIS. For doing this process you need to get some information from LDAP admins. Username and password to replace “wasadmin” user ( no-expire ) LDAP system user LDAP Hostname and IP Network access IDAP IP and Port Bind distinguished name Bind password Federated repository properties Unique distinguished …
The needs for LDAP Authentication on IBM Infosphere Information Server Read More »
Hi , Lots of application uses Oracle as a database. And first step of connecting an Oracle DB is install Oracle Client. In this blog I will show steps of installing and configuring Oracle Client 19C. Step1. Download Client from Oracle website ; https://www.oracle.com/tr/database/technologies/oracle19c-windows-downloads.html Step2. Extract the files and install the client ; Step3 : …