Free SAP C_BODI_20 Exam Dumps Questions & Answers

Your table contains the "sales_date" and "sales-time" fields both fields are data type archer (20). The "sales_date" format is 21-jan- 1980'. The "sales_time" format is '18-30-12'. You need to combine both fields and load the results into a single Target field of the data time data type. Which expression must you use to perform the conversion?

• A.to_data(sales_date&' '& sales_time.'dd_mmmm-yyyy hh24:mi:ss')
• B.to_data(sales_datell' 'll sales_time.'dd_mon-yyyy hh24:mi:ss')
• C.to_data(sales_datell' 'll sales_time.'dd_mmm-yyyy hh24:mi:ss')
• D.to_data(sales_date &' '& sales_time.'dd_mon-yyyy hh24:mi:ss')

Which two methods can you use to specify multiple files in the same source file format? (Choose two)

• A.Use wildcards(*.?)
• B.Specify a file Lookup table
• C.Use a comma separated list of files
• D.Create a file list .txt file

Which caching method reduces the amount of system memory used by the Table_ Comparison transform?

• A.Row_by_row select
• B.Cached comparison table
• C.In memory
• D.Pre_load cache

Where do you specify the columns for a template table?

• A.Import from the underlying database structure
• B.In the template table editor
• C.Cut/Paste from an existing query output
• D.In the output schema of the preceding transform

Which two types of database metadata can be imported by browsing? (Choose two)

• A.Stored procedure
• B.Trigger
• C.Table
• D.View
• E.Function