to follow, share, and participate in this community.
Not a member? Sign Up!
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... We just upgraded Informatica PowerCenter to 10.4.1 and enabled the postgresql plugin. Now I can create PostgreSQL connections but I don't know how to create source/target definitions without using the "PowerExchange ... Option to automatically remove unused ports in a mapping (or even across several mappings). This is known to speed up a mapping, but is easily forgotten during design. Lookup boxes should have a way... Hello, I am stuck at a point where I am not able to move forward. I am trying to find records that exists in Table B but not in Table A which is easy but the caveat is that I need a column in Table A that I need to us... Hello All, We are trying to implement a solution to get data from Rest API call. Would you please suggest or recommend a process using informatica Power Center how can we pass the bearer Authentication token... Hello, I am trying to achieve to write the [GLOBAL_SAHRED] as first line and date to the second line in a flat file in a single mapping. I am using dummy oracle as source and trying to create the output port and... Hi All, I have simple mapping which extracts data from source and deletes in target. It has composite primary key (composed of 10 columns). This mapping uses only those required 10 columns. I have not ... Hello Gurus, I am trying to read a file which has three columns. I created a mapping to read and in the second column I can have two values 'P' or 'F'. If I find the value P then exit code is 0 and workflow should be ... Hi everyone, I have a requirement to use oracle sequence next val to generate sequence at database. I have a mapping which is loading 3 separate tables using expression. However all 3 target tables ha... We are planing to update IPC 9.5.1 to 10.5. Is it necessary to make only consistently installing updates (9.5.1 => 10.1.1. => 10.5) ? Or will I can just install IPC 10.5 and use IPC clien... Hi everyone, My PWC version is 10.4.1 and I want to deploy it on my RHEL 7.8, but I got some problems. I list my steps following: 1. I download informatica_container_utility_linux-x64.zip and unzip it... Hello All, My requirement for Target_Field_A is as follows: If Source_Field_A like ‘%ORGIN%’ then set ORIGIN, Else if Source_Field_A like ‘%DEST%, then set DESTINATION. ... Hi All, Can any one guide on setting up the authorization for http transformation. The actual requirement is to authorize using bearer token to fetch data from Rest API and I am new to this area. But I saw som...