Skip to Content

Scenario Stuck In my SAP BODS Interview ?

Nov 29, 2017 at 11:12 AM


avatar image

I Have 1 Source Simple Query Transform and Target Table , After the first Execution of job i Want to replace or change the Source table .,, How will i Achieve this ?

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

1 Answer

Ravi kiran Pagidi Nov 30, 2017 at 10:11 PM

use SQL transform as source and parameterize (using global variable) the table name in SQL query in SQL transform.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Ravi , is it not possible without using SQL Transform as a source ?


We can also use conditional object where we create 2 dataflows. 1st dataflow with 1st source and place this dataflow in "Then" branch and 2nd dataflow with source table with which you want to change in "Else" branch of conditional object. when running the job for the first time set the Variable used in the if condition of conditional object, so that 1st dataflow will get executed. from next time default the variable used in the if condition so that dataflow in the else branch will get executed.