to follow, share, and participate in this community.
Not a member? Sign Up!
Hi all, Hope everyone is doing well! I am trying to import Maria DB tables in Powercenter 10.4.1. I've successfully created connection in ODBC Administrator using 'root' username, using Maria DB ODBC 3... Can anyone suggest sql query to find the mappings, session and command tasks associated with workflow for all project folders in PC 10.0? Hi. Can the powercenter 10.5 client tools be run on a Windows 7 VM? I have seen some issues reported on v10.2 but there appears to be a workaround using windows compatibility mode. Does this apply to 10.5 as well? Hi, I am trying to create a source definition by importing the client provided XML data file. But while importing the source definition, I get the following error: I am not the XML expert and not sure ... Hi, I am trying to use the following XML to create a source and further read the same file to load my table. Backyard Tee - Tequila Sunrise - Navy But I am stuck with the following error while readin... What is the lates verson of PowerCenter for Linux? Hello, I have a situation where I have an staged workflow in the WebServices And it is INVALID in the WS Hub but the Workflow is VALID The workflow consist in: 1 session -> multiple sessions (OR CONDITION) But... Hi All, Have tried lot of googling before posting this question here. So please provide your suggestions here Am calling a T-SQL Stored Procedure from Informatica Power Center thru SQ(SQL Qualifier ) T... Hi, I am just checking if there is an ability to interface with an API that requires oauth? Something like sending an authentication request, they respond with a token and we then send another ... Hi, I have incoming records with many different columns and I want one of the columns to have the same value repeated based on the first row. Example given below: In the Input source records, t... Hi, We have migrated from PC 9.5.1 on Solaris/Oracle to PC 10.4 on Windows/SQL Server and performance is less that impressive. Looking at the logs of a session would the following show the bottleneck is Inform... I've set a value of a mapping variable named $$TotalRecords during a mapping run. For the purpose of this question, the value of $$TotalRecords is 3. I want to use that variable value as a value in an INSERT sta... We have set up a DB2 server on Azure and link it to PowerCenter 10.5 Standard Edition. Under Designer we use 'DataDirect 7.1 DB2 Wire Protocol' under ODBC connection and can import table schema on DB2 database. Under ... could you please share the SAPNWRFC lib for SAP BCI extraction which supports Informatica Power center 10.5 We have a wf_DAILY workflow in PowerCenter Standard Edition 10.5 to be scheduled to execute on 01:00 every day after the daily batch. However, we want this workflow wf_DAILY to be called every day but checking the WOR... Hi All I have a table with following format with Col B as key. For group of values in Col B, if the col A has code as 'ABC', then that record has to be treated as Master record and rest of the records of that ... Hi Team, I would like to create a target file as zip file, now I am using output file type as command and creating the zip file. But after unzipping the fi... Hello, I am splitting a location field into 2 fields (location and location code). The format of the field is something like USA (USA1); so USA -> location, USA1 -> location_code. For loc... Does anyone know if PowerCenter's Web Service Consumer (WSC) transformation can be configured to add the Timestamp Created/Expired values to the WSSE Security Header (bolded in the example below)? A SOAP serv... Abstract You can configure Hive ODBC Connector for Cloudera Enterprise with PowerCenter® on Linux. This article describes how to install and configure the connector and also use the connector with the PowerCente...