I have a requirement wherein I need to join 2 tables and retrieve data from SQL server DB in CAI .
Please advice how to achive this.
You may try creating a view in the SQL Server and use that in CAI.
We cannot join two tables directly in CAI. We need to import the Data Access Service designed by Informatica.
Please go through the following article
Retrieving data ...