text: Having EMPLOYEE on both the SCOTT and USER schemas, and querying against the wrong table, can result in a problem that is difficult to detect. For this reason, the database adapter qualifies the table name with the schema name.
  You must use a transform with a for-each statement. An Assign activity with a too-simplistic XPath query can result in only the first employee being copied over.