Top "Informatica-powercenter" questions

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

Auto mapping target fields from source in informatica

I hav a source structure in informatica like col1 number col2 varchar(40) col3 DATE col4 varchar(50) col5 number and my …

etl informatica-powercenter informatica
Change mapping in the session

I have a Informatica session which is linked to a wrong mapping. How do i change the mapping from M1 …

informatica-powercenter
What are the types of datatypes in informatica and range of values they can take

I was trying to load data into db using informatica, where i used function to_integer() but it threw error …

informatica informatica-powercenter informatica-powerexchange
What is the difference between Informatica parameters?

What is the difference between $myvar and $$myvar parameters in Informatica PowerCenter?

informatica informatica-powercenter
Incorrect Special Character Handling in Informatica Powercenter 9.1

I am currently working on a project in my organisation where we are migrating Informatica Powercenter in our application from …

unicode informatica-powercenter codepages nls-lang
SSIS and Informatica

SQL SERVER 2014 SSIS has been released,we have already got lot of facilities in SQL SERVER 2012 SSIS.Can anybody compare …

ssis informatica-powercenter sql-server-2012-datatools sql-server-2014
Informatica writes rejected rows into a bad file, how to avoid that?

I have developed an Informatica PowerDesigner 9.1 ETL Job which uses lookup and an update transform to detect if the target …

data-warehouse etl informatica informatica-powercenter
Informatica Repository Query to get Workflow, Session, Mapping and Source/Target of Mapping

for cleaning up unused IPC-Sources I need a Repository Query for getting Workflow, Session, Mapping and Source/Target of Mapping.…

informatica informatica-powercenter
Is it possible to get the SQL that would be generated, without running the mapping?

We can see the SQL's generated by PowerCenter in the session log file once a mapping has been run. So …

informatica informatica-powercenter
Informatica: Prev column value display

The data in the source table is as follows: - Empno Ename sal 101 Allen 1000 102 Alex 2000 103 Tom 1500 104 Cb 2100 I want the …

informatica-powercenter informatica