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... 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. ... Is there an easy way to export mappings and workflow into a documentation type form of document? I saw a link to Marketplace but doesn't work. I also understood I could "export metadata" to Excel but I do ... 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, 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 ... 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... 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... 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... Gurus, for a given whole number or decimal I need to pad '00' to right and remaining zeros to left if the length is less than 12. For example if the number is 123 then 000000012300. Similarly for decimals if i h... 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 friends, I have a requirement in such a way that I have to use the target table as source to get the key value and update the same table. The reason being is i need to pull the file date from stage table. Appare... 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... 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 have a requirement to identify the records in history table that doesn't exist in stage table. The caveat is that I need to use the file date from the stage table to use as deactivation date and update history table... 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...