There is a need to extract millions of records from an Oracle database into BW for analysis. Which of the following represents the best ETL strategy? Select the correct answer.

Question

Options

• AModify a BI Content DataSource to include the Teradata fields in the extraction.
• BUse the File interface to extract manageable files of no more than 20,000 records each.
• CUse a WebService DataSource to stream the records into the PSA of the DataSource.
• DUse DB Connect for the ETL process.
• EUse UD Connect for the ETL process.

• A
  2% (1)
• B
  14% (7)
• C
  8% (4)
• D
  73% (37)
• E
  4% (2)

No community discussion yet for this question.