Skip to Content
0

Parent and Child Loading

Jan 05, 2017 at 03:06 AM

27

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ravi kiran Pagidi Jan 05, 2017 at 11:31 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded