How to use "And Process (Last)" process

[Former Member]

Hello,

I want to start index creation process when data are uploaded from all three data sources. How should I model my chain : version 1 or version 2.

version 1

data source1 data source 2 data source3

AND AND AND

index creation

version2

data source1 data source 2 data source3

AND

index creation

[Former Member · Accepted solution]

HI,

No need to use 3 times 'and'

use single to 3 DS

2nd version is suitable in ur case

data source1 data source 2 data source3

AND

index creation

-Shreya

[Former Member]

Use a single AND process.

But ensure that u have placed GREEN arrows from the 3 datasources to the AND process.

So that only when all the 3 loads are successful,will the index creation job run.

So 2nd version looks logical.

cheers,

Vishvesh

[Former Member]

Also better to have a 'drop index' process before you load data to cube,from the 3 datasources.

After drop index process place the 3 infopackages in parallel,and map GREEN arrows from 'drop index' process to the 3 infopackages.

Dropping indexes before loads will reduce load time and improve performance.

cheers,

Vishvesh