Innovation + Product Development

Nowadays when people talk about IT technology and trend, there was overwhelming world of big data as we entering the new technology era. I know that big data has been promoted to national strategy in many countries. A few days ago I found an interesting debate whether the traditional data warehouse will be replaced by […]

Target update override is also like source qualifier override. It is useful to update the target without using the update strategy transformation. You can find the Target Update Override option in the target definition properties tab. The syntax of update statement to be specified in Target Update Override is UDATE TARGET_TABLE_NAME SET TARGET_COLUMN1 = :TU.TARGET_PORT1, […]

What is Captcha? Sounds like a core technical jargon, which in reality isn’t. “Captcha is a type of challenge-response test used in computing as an attempt to ensure that the response is generated by a human being.” You might have noticed in some registration pages, at the end of it there is an image which has some letters displayed on […]

Business Objects provides a tool named Metadata Integrator to import relationship between universe and report. You need configure CMS(Central Management Server) and target database in Metadata Integrator first, then run, then it will load those relationship into target database. Below is window when data loading starts Here is description of related tables: Table Name Description […]

Before I start, let’s discuss why do we need automation? A very common answer would be to reduce human effort, time and most importantly to do regression testing again and again. I am working as an Automation tester along with the manual testing team. My task is to create regression test scripts in Selenium and deliver the […]

Scenario:  Sometimes people may input the wrong password several times, that will cause user locked by weblogic console, even reset password for this specific user in Admin console, still doesn’t work. So we need to unlock this user in Oracle weblogic console. Solution: Login to Oracle weblogic Admin console with other user account, click Lock & […]

In particular, this blog is provided by Aaron Dai. Perficient GDC has a team focusing on IBM WebSphere commerce development. To deliver client eCommerce solution with better user experience, the team devotes to learn technologies related to WebSphere Commerce project. As a member of it, I would like to share some experience of integrating UPS […]

Part 1: Requirement: 1. If there’s SR Number in the Subject, we have to create the Email – Inbound Activity for the inbound Email under the related SR. 2. If there’s Confidential in the Subject, we have to set the Private Flag to true for the activity we created. Part 2: How to set the […]

This blog tries to help you go through the process of creating a web service via Axis2/Java in Windows operating system. Axis2 is a Web Service engine and using Axis2 we can create our web services easily. Before we dive into the detailed steps, we need to get our tools prepared. Java, Axis2, of course, […]

We can use FOR XML PATH to combine rows.  For example, have the following data:   And I want to combine the value of column SRC_ID_SEED from all rows to a single row as:   We can achieve this by using FOR XML PATH(): select stuff((select ‘,’+cast(src_id_seed as varchar(20))          from DATA_SOURCES          FOR XML PATH ( […]

There are plenty of web pages to guide you how to install GitLab on an Ubuntu server. The official document in GitHub is also using Ubuntu as example.  You may follow them to install GitLab on Amazon EC2 Cloud Server but you may meet various problems that stop you from moving forward. I feel it […]

  Scenario: Data source is a flat file and we want to load this data into the target. The problem is the source file name keeps on changing.  Here we go: Use a pre-session script that creates a file list. Windows dir /b part_of_file_name*.txt > FILELIST_NAME.LST UNIX ls part_of_file_name* > FILELIST_NAME.LST                 In Workflow Manager […]