Top "Informatica-powercenter" questions

Informatica Powercenter is an ETL (Extract, Transform, and Load) tool developed by Informatica Corporation.

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
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
Informatica SET Mapping variable

I'm new to informatica. I defined a mapping variable in the 'parameters and variables' option in a mapping. Now in …

informatica-powercenter
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
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
What is the required language knowledge to use Informatica effectively?

In the next few weeks, my company will be engaging multiple vendors to establish a choice for a common global …

etl talend informatica-powercenter
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
Informatica - Duplicate elimination

I am having a flat file with 10 records, and out of it 5 records are duplicate records (unique key column: Customer_…

informatica-powercenter
Set Mapping variable in Expression and use it in Source Filter

I have two tables in different databases. In a table A is the data, in the other table B are …

informatica informatica-powercenter
loading data from a flat file to table using informatica, having both english and foreign language characters like chinese

I am loading data from a flat file to table using informatica, the file has both english and foreign language …

utf-8 character cjk informatica-powercenter