Hi is there any way we can query and check what are the sessions which are using post and pre sql commands and what they are? right now i am using this query but it is not returning the DDL …

Informatica documentation shows, we can override where clause too. so, keep on trying to override with inline variables. I had to implement by using SQL transformation

I need query to get connection names, database server names and databases names for all the workflows/sessions which are in a particluar folder by using Repository tables.

We are using SQL query to join both tables and we have to use single mapping as parameterized to load incremental. In IICS when I use source type as Query, I am not able use parameter for the …

We are new to Informatica and have created simple mappings, mapping tasks and taskflows. We are now trying to get a SQL stored procedure working. Anyone have any advice on how to one working …

Informatica Repository Query to get Pre/Post SQL statements In my mappings I have targets which have Pre and Post SQL statements to drop/create indexes. How can I get a list of all Pre and Post …

Oct 3, 2024 · The connection you have chosen is mysql in Informcatica. However, it needs to use the driver installed in the agent machine whose name is : "MySQL ODBC 8.0 Unicode Driver" Because …

Have you tried connecting to DB from outside like SQL Server client before, if yes you can check what all properties were specified while connecting from there.

using SQL query I can use like " where Name LIKE '%JOHN%' ", but same thing how to implement in Expression Transformation, I can't use even sql override at SQ there are many other transformation …

1) i need to send sysdate to sql server target column, but that column has datetime datatype with length 23 by default , when informatica sends sysdate it will send with milli seconds too so it will be more …