Free Preparation Discussions
MENU
Appian Exam ACD101 Topic 3 Question 35 Discussion
Topic #: 3
You have two Custom Data Types (CDT): ACME_invoice and ACME_invoiceItem that have a flat relationship.
The invoice item table has a field that is a foreign key to the invoice table. You are leveraging the database to automatically generate their primary keys.
How should you structure the process model to add a new invoice and the new invoice items to the system?
When dealing with related data types where one has a foreign key to another, you must first create the record in the primary table (ACME_invoice) and then use the generated primary key to create related records in the secondary table (ACME_invoiceItem). This is why you first write to the ACME_invoice table, then update the foreign keys in a Script Task, and finally write to the ACME_invoiceItem table.
Appian Documentation: Relational Databases
Jose
1 months agoPura
1 months agoCasey
3 days agoFrancesco
5 days agoTrinidad
7 days agoClorinda
8 days agoLennie
1 months agoMurray
1 months agoHillary
7 days agoChrista
20 days agoKarma
1 months agoEttie
2 months agoChauncey
1 months agoJanine
1 months agoFausto
2 months agoRoyce
2 months agoLuke
2 months agoFlo
3 months agoLuke
3 months ago