Parent and Child Loading

[Former Member]

Hello All,

I need to load data into the target table based on the constraint , eg -if we want to load the EMP&DEPT data, first it loads the data of DEPT then EMP because DEPT is PARENT table EMP is CHILD table. In simple terms, it loads PARENT table first then CHILD table.

How this can be achievable in BODS.

[former_member208402]

Hi Vinay,

simple... create a job.. take 2 dataflows in it and connect both the dataflows. in 1st dataflow load DEPT table and in 2nd dataflow load EMPLOYEE table..

1st dataflow will be executed first and then 2nd dataflow.