Question

1
Replies
1293
Views
Close popover
Sreedhar Bandaru (BANDA2011)
Ernst & Young, LLP

Ernst & Young, LLP
US
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.