When you import InfoSources or DataSources into the Target Designer, the PowerCenter repository stores them as target definitions. You can use these target definitions in mappings that load data into SAP BI.
The following restrictions apply to building mappings with InfoSource and DataSource targets:
You cannot use SAP BI as a lookup table.
You can only use one transfer structure for each mapping.
You cannot execute stored procedures in an SAP BI target.
You cannot build update strategy in a mapping. SAP BI supports only inserts. It does not support updates or deletes. You can use an Update Strategy transformation in a mapping, but the PowerCenter Integration Service attempts to insert all records, including those marked for update or delete.