Skip navigation

3 Replies Latest reply on Dec 6, 2018 8:19 AM by Srini Veeravalli

Regarding unconnected looups using snowflake as database

sandeep kumar Dec 5, 2018 11:21 PM

Hi All,

We are trying to migrate our database from oracle to snowflake and we are facing an issue as for the mappings in IICS the cloud does not support the unconnected lookup on snowflake database. Do anyone have any specifics about this issue. I know I can convert it to connected lookup but this is something which needs to be resolved from informatica end. Please provide some insight on this.

Cheers

Sandeep

1. Re: Regarding unconnected looups using snowflake as database

Srini Veeravalli Dec 6, 2018 5:29 AM (in response to sandeep kumar)

I dont see any comment on unconnected lookup in https://network.informatica.com/onlinehelp/IICS/prod/CDI/en/index.htm#page/cloud-data-integration-snowflake,-connector-g…
Like Show 0 Likes(0)

Actions
2. Re: Regarding unconnected looups using snowflake as database

Nitin KN Dec 6, 2018 8:16 AM (in response to sandeep kumar)

if the un-connected check box is greyd out it means un-supported.
Like Show 0 Likes(0)

Actions
3. Re: Regarding unconnected looups using snowflake as database

Srini Veeravalli Dec 6, 2018 8:19 AM (in response to sandeep kumar)

Note: You can use an unconnected lookup only with a database or flat file data source.
https://app3.informaticacloud.com/saas/v389/docs/EN/index.htm#page/jj-cloud-transformations/Unconnected_Lookups.html
Like Show 0 Likes(0)

Actions

Go to original post

More Like This

Legend

Correct Answers - 4 points