Free Preparation Discussions
MENU
Appian Exam ACD101 Topic 1 Question 18 Discussion
Topic #: 1
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
Carlene
3 months agoJutta
3 months agoMauricio
2 months agoGilberto
2 months agoDaron
2 months agoJarvis
2 months agoTony
3 months agoJoseph
3 months agoPansy
3 months agoHuey
3 months agoAlberto
3 months agoAlayna
3 months agoYvette
2 months agoGerry
3 months agoStephane
3 months agoErnest
3 months agoOretha
3 months ago