SAP Certified Application Associate - SAP BusinessObjects Data Integrator XI R2 - C_BODI

Question 1

What is the function of the Merge transform?

A. To append two column values together B. To apply an auto update to your target table C. To join incoming data sets based on a relationship D. To apply a union all to the incoming data streams.

Discussion 0

Correct Answer: D Vote an answer

Question 2

How do you commit all rows in a single transaction?

A. Specify the "Number of loaders" equal to one. B. Select "Commit at the end of Insert... Select" C. Select "Include in transaction" in the target table options D. Specify "Rows per commit" equal to zero

Discussion 0

Correct Answer: C Vote an answer

Question 3

Which two syntactical items can you check by selecting "Validate All"? (Choose two)

A. Existence of variables B. Contents of SQL function calls C. Contents of SQL transform D. Job structure

Discussion 0

Correct Answer: A,D Vote an answer

Question 4

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

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

Discussion 0

Correct Answer: A,D Vote an answer

Question 5

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_datell' 'll sales_time.'dd_mon-yyyy hh24:mi:ss') B. to_data(sales_date&' '& sales_time.'dd_mmmm-yyyy hh24:mi:ss') C. to_data(sales_date &' '& sales_time.'dd_mon-yyyy hh24:mi:ss') D. to_data(sales_datell' 'll sales_time.'dd_mmm-yyyy hh24:mi:ss')

Discussion 0

Correct Answer: A,C Vote an answer

Question 6

Which two steps are part of the profiling configuration process? (Choose two)

A. Use the Data Quality dashboard to review high level profiler result details B. Use the Repository Manager to create/update/delete profiler users C. Use the Repository Manager to create the profiler repository D. Use the Server Manager to associate the profiler repository with the job server

Discussion 0

Correct Answer: C,D Vote an answer

Question 7

What is the function of the Case transform?

A. To join data sets from separate streams based on conditional logic. B. To split data sets based on conditional logic into separate streams. C. To select a Job path based on conditional logic. D. To map a column value based on multiple conditions.

Discussion 0

Correct Answer: B Vote an answer

Question 8

Where is the data stored for a template table?

A. Underlying database table only during execution B. Underlying database table during and after execution C. Job Server memory during Job execution D. Job Server memory during and after Job execution

Discussion 0

Correct Answer: B Vote an answer

Question 9

Which three objects does the Management Condole "Iplact and Lineage analysis" capture? (Choose three)

A. SQL transform tables B. Source tables C. Target files D. BusinessObjects universes

Discussion 0

Correct Answer: B,C,D Vote an answer

SAP Certified Application Associate - SAP BusinessObjects Data Integrator XI R2 - C_BODI_20 FREE EXAM DUMPS QUESTIONS & ANSWERS