How can we convert Informatica Mapping to Snowsql queries.

We have a requirement where we are migrating to Snowflake datawarehousing, so our project is a need to convert Informatica mappings to snowsql queries. I am very new to snowflake and want an understanding if this can be done or its complex task. Any help will be appreciated.

anu09sha

posted on 02 Mar 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds




nVector03-Mar-20

Do you want to convert informatica logic to sql? Or trying to port the informatica mappings from your old database to snowflake ?

If it’s the former I’m not aware of any automated way to convert an informatica mapping into SQL, it has to be done manually

Anusha, I have an automated solution for you. Let me know how I can get in touch with you. You can reach me at vilas.g.deshmukh@gmail.com. Thanks. Vilas.

gkaushik29-Mar-21

Hi Vilas -

Do you have a product for Informatica to Snowflake conversion or it's a SQL ?

regards

Gaurav kaushik