Most of my company uses powercenter informatica for Extract-Transform-Load type data move jobs between databases. However project I am on has a big custom Perl job with some Java thrown in for go...

We are trying do a proof of concept on Informatica Big Data edition (not the cloud version) and I have seen that we might be able to use HDFS, Hive as source and target. But my question is does Inf...

In the next few weeks, my company will be engaging multiple vendors to establish a choice for a common global ETL tool - not necessarily one that can't be broken from, but just where our license in...

SQL SERVER 2014 SSIS has been released,we have already got lot of facilities in SQL SERVER 2012 SSIS.Can anybody compare SSIS 2014/SSIS2012 with Informatica Power center ? What are the additi...

I have a Informatica session which is linked to a wrong mapping. How do i change the mapping from M1 to M2 in the same session S1 and Workflow W1 WITHOUT importing/exporting as XML and making the c...

I hav a source structure in informatica like col1 number col2 varchar(40) col3 DATE col4 varchar(50) col5 number and my target definition is like col4 varchar(50) col1 number col5 number col3 v...

Could anyone help me with writing case statements in Informatica PowerCenter Designer? I am fairly new to Informatica, and based on my limited experience I feel case statements aren't supported. Th...

Oracle Details:- Oracle 10g Enterprise Edition Host running XP x32 I use scott tiger for logging with SQL* Plus . I dont provide any HOST STRING. How can i setup Oracle to accept Host String ? i...

In the past, I have used Informatica for some ETL (Extraction Transformation Loading) but found it rather slow and usually replaced it with some PL/SQL scripts (was using Oracle at the time). (que...

I'm sure that this is a pretty vague question that is difficult to answer but I would be grateful for any general thoughts on the subject. Let me give you a quick background. A decade ago, we use...