Skip to Content
-1

Scenario Stuck In my SAP BODS Interview ?

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.