How would you use the View Optimized SQL feature to optimize the SQL feature to optimize the performance of the dataflow?
You are reading a Sales Order table from the source and need to add the customer region information a from a customer table. The primary key of the customer table consists of the columns CUST_ID and VALID_FROM
How would you desing the dataflow to get the region information that was valid at the ORDER_CREARTE_DATE?
An SAP data services file format has a date column, but occasionally the file contains an invalid value in one row. This causes the dataflow to terminate with an error.
What can you do to completely load such erroneous files?
Note: There are 2 correct answer
You are reading a Sales Order table from the source and need to add the customer region information a from a customer table. The primary key of the customer table consists of the columns CUST_ID and VALID_FROM
How would you desing the dataflow to get the region information that was valid at the ORDER_CREARTE_DATE?
An SAP data services file format has a date column, but occasionally the file contains an invalid value in one row. This causes the dataflow to terminate with an error.
What can you do to completely load such erroneous files?
Note: There are 2 correct answer
Submit Cancel