Question

3
Replies
224
Views
MuraliK9593 Member since 2016 10 posts
SMS Management & Technology
Posted: 3 years ago
Last activity: 3 years 9 months ago
Closed
Solved

Transform data using BIX

Hi,

Is it possible to transform data in BIX ectract rules?

For example, we have FirstName (Alpha) and LastName (Beta) properties in Pega DB. In the BIX extract to a database we want to concatenate values of FirstName and LastName separated by a space and insert value into a column called Full_Name (Alpha Beta) of taget database table.

I have gone thorugh the BIX documention and also help file for BIX extract rule but I did not find any such configurations being available in BIX. My understanding of BIX is that it is juat an "extract and load" tool. It is not "extract, transform and load" tool. Is this correct?

Pega version: 7.2.1

Regards,

Murali

***Updated by moderator: Lochan to add Categories***

Data Integration System Administration
Moderation Team has archived post
Share this page LinkedIn