An SAP Data Services dataflow must load the source table data into a target table, but the column names are different. Where do you assigg each source column to the matching target column?
You are asked to perform either the initial load or delta load based on the value of a variable that is set at job execution
How do you design this requirement in SAP Data services.
A SAP Data Services job contain logic to execute different dataflows depending on whether the job was successful or failed. Therefore the $NEEDS_RECOVERY variable should be set to either 'Yes' or 'No'. How do you assign the value to the $NEEDS_RECOVERY variable?
Why would you use a memory datastore in your SAP Data Services dataflow design?
You want to set up a new SAP Data Services landscape. You must also create new repositories. Which repository types can you create?
