Question

1
Replies
1275
Views
BANDA2011 Member since 2010 13 posts
Ernst & Young, LLP
Posted: February 13, 2017
Last activity: February 13, 2017
Closed

Connect SQL rules

1. We know that using Obj methods is always a good practice and using RDB methods is not a good practice? Is there any particular reason why using RDB methods is not a good practice?

2. In the below example, what happens if the data type of "Column1" and "Property1" doesn't match?

Select Column1 as ".Property1"

3. Is there any significance of Applies To class in which you write a Connect SQL?

For example, if I write a Connect SQL in class "Data-HR-KB-Employee" and my SQL uses the where clause "Data-Customer-Address-Details", what is the background algorithm PEGA uses to execute this CONNETC SQL rule?

Applies to : Data-HR-KB-Employee

where {class:Data-Customer-Address-Details}

Data Integration
Moderation Team has archived post
Share this page LinkedIn