to follow, share, and participate in this community.
Not a member? Sign Up!
Hello, My source is a flat file with 84 columns out of which there are 6 date columns. The date columns format in source file is YYYY-MM-DD and the values in some of these columns are nulls. The datatype for... Hello, I have PowerCenter 9.5.0. I'm accessing the Admin Console like so, www.machinename:port/adminconsole. When logging into the Admin Console and under Doman>Services and Nodes, I click the Integration Service.&... Hello Gurus, I have a dimension table with surrogate key as the primary key. Employee_identifier is the key which is used to lookup and maintain SCD Type 2 history in the table. Employee_identifer is a 7-digit... I have installed Informatca 10.4.1 and installed developer client. But Developer client is not opening. I have installed jdk 16 also. I have checked metadata logs, below error is showing. Attached metadata logs. Pleas... Hello Everyone: IBM-Redhat has moved to the higher version of RHEL and the current 7.8 which is supported by latest Powercenter 10.4.1 is about to move into extended support, which customers are forced to purc... Hello All, I am creating a mapping where Teradata table is a source and target is a flat file(.csv). I am reading the entire data from the source table (17256447 records). Since the source count is huge, so I... I have a requirement where I have to create a custom header & trailers (hard code values) in a fixed width file and then the data. Any suggestions please? Planning to incorporate in one mapping. So In exp... Hello Can someone share the release date of PC 10.5.x and also the PAM.? I am curious to see if we this supports RHEL 8.x which is very much needed. Thank you Gurudutt Hi guys! I'm deploying IPC on AIX, could you please share with me some expertise or maybe there some calculator for sizings? Appreciate it Hello experts, I'm searching to get some details on Informatica Powercenter real time performance tuning. I'm working in Informatica for last 2 years but till now I did not get a chance to work with huge... Hello All, ######## I want to achieve this via Shell Scripting ######## I have a requirement to move a file(which will come on a daily basis) in unix box location (data/infa_shared/SrcFiles/ABC/). The ... Hello All, For my requirement, Source is a Hive database and Target is flat file(in .csv format). Now I want to handle both comma , and double qoutes “ and newline as well Below is the sample dat... All, We are in the process of migrating Netezza appliance to Yellowbrick on cloud towards end of this year. Has anyone started this migration or planning to do so. Please share you thoughts and experienc... I'm trying to fill out a form for Informatica Cloud Data estimate.In that they are asking about No of jobs, mbs and % . Can anyone suggest how can we determine mbs and % in PowerCenter 10.0? Hi all I have a java transformation which I'm trying to use to parse a json file. I declare the object "ObjectMapper" and in order to compile it I've added the following .jar libraries in the java tx (settings tab):... Hi Team, I need to run the Wf 10 times every day from Monday to Friday, i have set the bellow properties and wf was running on the day it was scheduled but not scheduling for the next dates. using informatica... Hello, We have an old Workflow Builder app developed in VBA which uses the mapfwk API in version prior to PWC v9.5. We are currently using PWC v10.2 and PWC v10.4, when generating the Timestamp type is not rec... Hi, I am trying to parse an xml file using power center mapping designer and it gives me the following error: I tried uncommenting the below line in C:\Informatica\10.2.0\server\bin folder and added this as a... Hi All, I am trying to importing mapping which consists of shared objects (source/target). I imported the shared objects first and when i tried to import the mapping,mapping getting imported but the links to ... Hello, I am trying to connect to a PostgreSQL database in Informatica PowerCenter, but there seems to be no option available. I read that I can use ODBC instead but there is only an option "ODBC for Oracle", "...