Results 1 to 3 of 3

Thread: Row Count

  1. #1
    Join Date
    Dec 2005

    Unanswered: Row Count

    I am using business object data integrator v11.5 that runs on oracle data base, I want to be able to record the number of rows from the source vs target.

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    As I know nothing about business object data integrator v11.5, this may be a complete nonsense ... however, a little chat might help.

    Record count is performed using the COUNT function. A simple example would be this:

    SELECT COUNT(*) source_records FROM source_table;
    SELECT COUNT(*) target_records FROM target_table;

    Comparing those values will show the difference.

    If this makes sense, we could go a step further: including a WHERE clause which will restrict output data set, for example:

    SELECT COUNT(*) source_records FROM source_table
    WHERE department_id = some_value;

    I'll say it again - there is a high probability that you won't find it helpful at all ...

  3. #3
    Join Date
    May 2004
    BA [ARG]
    SELECT src.source_records, trg.target_records
      FROM (SELECT COUNT(*) source_records FROM source_table) src
         , (SELECT COUNT(*) target_records FROM target_table) trg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts