Dynamic Partial Reload for data model ?

[raju_insights]

Hi Techies,

I am initiating a partial reload from a batch file. This partial reload is done for a data model. The tricky part is that, I have to switch the partial reload between tables from an excel input. How can I achieve this. Any Ideas???

[sunny_talwar]

Rangaraju Rajappan wrote:

I have to switch the partial reload between tables from an excel input.

Can you elaborate a little more on this?

[raju_insights]

Hi Sunny,

Lets say In data model I have two tables. I am performing partial reload on these two tables based on the input from an excel.

Example:

Input from Excel:

Name     Reload Status

Table1    Y

Table2    N

When I perform Partial reload, Table1 alone should reload.

Suppose,

Input from Excel:

Name     Reload Status

Table1    N

Table2    Y

Now, When I perform Partial reload, Table2 alone should reload.

[sunny_talwar]

Oh ya, I think this is def. doable using if statement. I guess store the values of your inputs into a variable and do a partial reload only if there is Y

If $(vTable1) = 'Y'

     Add/Replace Only

     LOAD ....

     FROM Table1

ENDIF

If $(vTable2) = 'Y'

     Add/Replace Only

     LOAD ....

     FROM Table2

ENDIF

[raju_insights]

Hi Sunny,

Here I have attached the setup. I have implemented the same logic which you shared. But when I do partial reload no table is being reloaded. (I have given condition to reload table2) .

I guess "partial reload" and "If..Then" wont sync. Am I going wrong or is there any other way to achieve this.

[sunny_talwar · Accepted solution]

Give this a try now

[raju_insights]

Awesome Sunny! it is working. Thanks .

[sunny_talwar]

Great, I am glad it does

Best,

Sunny