informatica

informatica integration service treats filter transformation as passive transformations ?

i had a question from my training.does the integration service treat the filter or update transformation as passive transformations ? ...

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 tool - not necessarily one that can't be broken from, but just where our license investment will go to consolidate those costs. Two of the major players are Talend and Informatica, with others that are unimportant for the sak...

SQL Query in Informatica Cloud

I am trying to integrate a MySQL database with Salesforce but am having trouble with part of the query logic. I enter this query: SELECT occupation_name FROM skillsmatch_skillsprofile GROUP BY time_updated ORDER BY time_updated DESC LIMIT 0,5 But get this error: <> missing operator... SELECT>>>> <<< Any idea where I might be going w...

AS400 to Oracle 10g via xml with Informatica Powercenter

Is the following workflow possible with Informatica Powercenter? AS400 -> Xml(in memory) -> Oracle 10g stored procedure (pass xml as param) Specifically, I need to take a result set eg. 100 rows. Convert those rows into a single xml document as a string in memory and then pass that as a parameter to an Oracle stored procedure that is ...

Can I unit test Informatica Powercentre workflows?

Can I unit test Informatica Powercentre workflows? EDIT: More specifically, can I mock sources and target and test the steps in between? Eg. If I have a workflow with a Oracle source and a text file target can I test it without Oracle and a text file.? ...

DTS/SSIS vs. Informatica Power Center

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 used to write data loads reading input flat files from legacy applications and load them into our Datamart. Originally, our load programs were wr...

loading the target tables

if suppose i have source with seven records from that first three must go in 3 target instances and 4th record again have to go into first record how can i achieve it? ...

informatica powercenter FTP issue

Hi, I'm facing an issue on a FTP I would like to know how, and the best option for the below situation. I'm dealing with a process that connects via FTP and gets a file, using JMS on Informatica Powercenter. I would like to know if there is a way to get the log saying that there was a problem on the connection and rerun the process, v...

informatica problem

Facing Error: *cannot start the server 'servername' * when trying to start the workflow, iam getting the above error. I have configured server settings properly and it resolved as well.. all the informatica services are running fine. what could be the problem. ...

DB2 DBA, Data-Warehousing and BI training

I want to take DB2 DBA certification and also want to learn Data-Warehousing and Business Intelligence. I want to know: (1) Whether DB2 DBA certification is demanding or not. I am a .NET developer since last three years and IT experience is even more. I worked on Oracle, MySQL, SQL Server and used DB2 also for some applications. For suc...