Top "Informatica" questions

Informatica is a software development company which provides multiple UI based tools for Data Integration, ensuring Data Quality and Master Data Management.

Case Statements/Decode Function in Informatica

Could anyone help me with writing case statements in Informatica PowerCenter Designer? I am fairly new to Informatica, and based …

decode case-statement informatica-powercenter informatica
The Repository Service marked the session or session instance as impacted

I am new in control-M. I have a work flow that i developed in Informatica....When i run the work …

informatica
How to convert string into number using expression transformation in informatica?

I have source column(amount) with datatype string, contains the datas like $793.00, $5791.00,... I need to load this same data into …

informatica
How to dynamically give flat file source file name in session properties of informatica?

i have an issue where i get flat file with date and time extension to flat file name like test_28…

flat-file informatica-powercenter informatica
IIF statement in SQL/ Informatica ( expression transformation) with two values

I have the following SQL statement which check for the presence of 000. But what if I want to check the …

sql informatica iif
Difference between Joiner and Union Transformation

I'm new to Informatica....What is the difference between Joiner and Union Transformation? Also, Should we use Router instead of …

informatica informatica-powercenter
Microsoft ODBC Driver 13 for SQL Server : Login failed for user 'sa'

Im installing the MDM of Informatica. MDM 10.2 - Jboss 6.4 EAP - SQL Server 11 - Windows Server 2008 R2. During the creation …

sql-server sql-server-2008 informatica mdm
Informatica issue - Parameter file

My source is dat file. Intially in designer I can I import the file from my local. But later it …

informatica-powercenter informatica
find the list of mapping and workflow affecting the particular table in informatica

Can anyone tell me how to find the list of mapping and the workflow that are using a particular table …

informatica informatica-powercenter
Snapshot too old error

I am getting 'snapshot too old error' frequently while i am running my workflow when it runs for more than 5 …

oracle teradata informatica