Question

2
Replies
369
Views
 Dyan Baur (DyanG412)
Hawaii Medical Service Association

Hawaii Medical Service Association
US
DyanG412 Member since 2013 212 posts
Hawaii Medical Service Association
Posted: February 24, 2016
Last activity: February 24, 2016
Posted: 24 Feb 2016 8:41 EST
Last activity: 24 Feb 2016 10:49 EST
Closed

how does the BIX and Target database handle the pagelist properties and their values?

how does the extraction of pagelist to database is handled? does it directly create new columns for additional properties in the pagelist?

Pega Customer Service Data Integration
Moderation Team has archived post, 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.
Posted: 5 years ago
Posted: 24 Feb 2016 8:50 EST
Celeste Dufresne (CelesteDufresne_GCS)
PEGA
Principal Software Solutions Engineer
Pegasystems Inc.
US

When scalar properties in an embedded value list, page list, value group, or page group have been

selected for extraction to a CSV file or to a database, BIX generates a separate CSV extract file or

a separate database table for the embedded properties. BIX promotes scalar properties of

embedded pages (not page lists or page groups) to the parent node.

When you run the extract to generate the schema that you need to apply it will have the "create table" statements for the top level table and any tables needed for value list/group and page list/group properties.