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 a informatica mapping in which csv is the source file for the target table. ABC_ID XYZ_CODE are the 2 fields I am looking at mainly. If ABC_ID in the csv file is more than once, ... I have Flat File1 (F1) with these columns - key1, col1, col2 Flat File2 (F2) with these columns - key2, col1, col2 and one table (T1) with these columns - key3, col1, col2 Requirement is to get data from all 3 sources... 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.&... 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... We are getting inconsistent behavior with Informatica Salesforce Connector . We get "HadoopBatchDTM-pool-4-thread-9262> SEVERE: SalesforceConnection-10122: Login failed. User . Fault code [SERVER_UNAVAILABLE]. Re... 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. ... hello to all. I have a question about this case that I have in database and I want to pass it to powercenter, I do not know if it is better to use iif or decode for its transformation to powecenter. If you could hel... Create reusable wOrkflow to check/ping the database (Oracle ) connectivity...and send emails ( Failure emails ) if the connection is not successful. I am thinking of creating a reusable command task to ping Or... I have a scenario where we are using a date column "SRC_CREATED_DATE" in Informatica, Can anyone suggest to me how this can be done for example my min date is "20-AUG-2003 00:00:00" and my maximum date is "27-APR-2021... 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 ... Hello, We have security issues on the ports 10123 and 10127. 10123 = administration console 10127 = pmserver Is it possible to disable TLS 1.1 protocol support on ports 10123 and 10127? Is it possible to use ... Hi All I meet an issue and need help . Now I need use pmcmd to run workflow, but when try to run pmcmd ,it failed to start pmcmd. Not sure what happened. system : Windows ... Hi, I have a use case to use python in conjunction to informatica powercenter. Below is what we are currently doing Installed native python on infa server but no modules installed. Curr... 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... Has anyone used Visual Studio to usr Git and PC? I need to manage version control using Git. I have done it using Jenkins which supplies a hook to call a Linux Script to do the export, etc and load the XML int... When I do object Import is there anyway in adding text to an object such as the description field of a workflow? Has anyone used Visual Studio to usr Git and PC? I need to manage version control using Git. I have done it using Jenkins which supplies a hook to call a Linux Script to do the export, etc and load the XML int... I am planning to give this certification, where can we get the study material along with content to study for this certification if one has to not pay for the trainings provided by Informatica university on the traini...