to follow, share, and participate in this community.
Not a member? Sign Up!
My requirement is to pull data from Hive tables and dump it into the Impala table using powercenter ODBC Connection. I am using Imapala ODBC connection to write to target table. This is simple one to one mappi... 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... Please forgive me for such a noobie question, my company has tasked me with doing some work with PowerCenter and I have not yet been to training. I've designed a workflow that will take an XML input source and... Hello Everyone, We are in the process of upgrade from 10.2HF1 to 10.4.1 or 10.5. I came across an issue with the Application connectors with 10.4.1 where the standard or DBConnection*** does not support ... Can Informatica connect to IBM DB2 11.1 at Database OS SuSe Linux Enterprise Server 12 SP4 ? as per PAM sheet for Informatica 10.4, Informatica support IBM DB2 11.1 at Database OS SuSe Linux&... 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... Hello GURUs I'm trying to configure an http transformation in order to load data to a web service using POST method. The webservice provider has gave me a json sample to make me build the ws request. It is ve... If I change log options in the default session config. Do I then need to check-out, save, and check-in all the workflows that use that default session config, or will the workflows just pick on the changes automatical... 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 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... Hi, i too have requirement to get the cookie value from Http Transformation in Power center. As of now i am able to get the ASP.NET_SessionId from HTTP_OUT. But i also need AWSALB from cookie. ASP... Hello, we are facing a performance issue reading and writing (update) on SQL Server database. We have installed the Informatica 10.2.0 HotFix 2 on Windows Server 2016. The mapping is a simple pass-through (attached... 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? Hello, I am trying to create a Informatica mapping where in the Source Qualifier "PRE" or "POST" SQL, I want to call a Oracle Stored procedure with parameters Dynamically. Below is the more detailed Requireme... 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, I have requirement to load 6 flat files into the target table which are of same structure. I know, we can achieve this by using indirect load option. But I wanted to know what are the best prac... 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 ...