Skip navigation

2 Replies Latest reply on Jan 12, 2021 7:47 AM by Prathap Reddy

Join 2 tables and retrieve data in CAI

User6392 N Jan 12, 2021 12:58 AM

Hi Team,

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.

TIA

1. Re: Join 2 tables and retrieve data in CAI

Nithy S Jan 12, 2021 6:55 AM (in response to User6392 N)

Hi @User6392

You may try creating a view in the SQL Server and use that in CAI.

Thanks!
Like Show 0 Likes(0)

Actions
2. Re: Join 2 tables and retrieve data in CAI

Prathap Reddy Jan 12, 2021 7:47 AM (in response to User6392 N)

Hi @User6392,

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

Support

Thanks,
Reddy
+91-9989045104
Like Show 0 Likes(0)

Actions

Go to original post

More Like This

Legend

Correct Answers - 4 points