Follow the below obiee 11.1.1.7 certification matrix http://www.oracle.com/technetwork/middleware/bi/bi-11gr1certmatrix-ps6-1928219.xls 

Can you please explain how to get sub sting using CAST function in RPD.

Opaques are only used when there is no other way to get to the final solution. if you go for Opaques better deploy opaque view in to database to reduce the burden on BI Server.

Use Opaque view in RPD Physical Layer.

Thanks Christian for the update , but i am not able to open your answer. can i have the link.

is the column requested_qty is fetching data from source ? if it is map the column to target table and load the data. if the table w_rqstn_line_cost_f is already populated except the requested_qty column ,create a separate cut-over mapping to load this column.

yes, it is possible to load incremental from server2. 1) complete DAC load with Server1. 2) migrate the DAC meta data DB from server1 to server2. 3) connect Server2 DB with Server2 DAC. 4) you can find all the server2 DAC setup looks same as Server1 DAC setup 5) validate refresh dates and infromatica , source and target…

Check the informatica Repository server and Integration servers are able to connect from DAC->Setup->infromatica Servers.

set the connectivity perimeters for the Execution plan and generate parameters and Build the Execution plan.

insert data source number in DAC at Setup->Physical Data sources->Edit -> Data Source Number.