• Date columns causing table load issues

    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...
    Vindhya Giri
    last modified by Vindhya Giri
  • Logic implementation in Informatica mapping

    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, ...
    Vindhya Giri
    last modified by Vindhya Giri
  • joiner transformation query

    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...
    AW Khan
    last modified by AW Khan
  • PowerCenter Integration Service in Admin Console hangs

    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.&...
    Michele DuBose
    last modified by Michele DuBose
  • Impala table Error by using powercenter through Impala ODBC connection

    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...
    Salman Khan
    last modified by Salman Khan
  • Primary Key change and SCD Type 2

    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...
    Divya Karun
    last modified by Divya Karun
  • SalesforceConnection-10122: Login failed. User .Fault code [SERVER_UNAVAILABLE]. Reason [server temporarily unavailable]."

    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...
    Varadaraj Bhat
    last modified by Varadaraj Bhat
  • REG_MATCH expression

    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.  ...
    Divya Karun
    last modified by Divya Karun
  • problem case powercenter

    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...
    Álvaro Moreno Iruela
    last modified by Álvaro Moreno Iruela
  • Create reusable wOrkflow to check/ping the database (Oracle ) connectivity...

    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...
    sri gar
    last modified by sri gar
  • How to Implement Key Range partition in Informatica using a date column

    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...
    KARTHIK CM
    last modified by KARTHIK CM
  • Mapping and Workflow documentation

    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 ...
    Dianna Gibbs
    last modified by Dianna Gibbs
  • Security On the PowerCenter 10.2HF2

    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 ...
    Jordan Abadie
    last modified by Jordan Abadie
  • PMCMD can't run

    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 ...
    Wenyuan Du
    last modified by Wenyuan Du
  • powercenter & python

    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...
    EC137656
    last modified by EC137656
  • Developer Client 10.4.1 is not starting

    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...
    Rajesh Audhivanne
    last modified by Rajesh Audhivanne
  • PowerCenter and GitHub

    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...
    John Lyons
    last modified by John Lyons
  • ObjectImport

    When I do object Import is there anyway in adding text to an object such as the description field of a workflow?
    John Lyons
    last modified by John Lyons
  • PowerCenter, Git, and Visual Studio

    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...
    John Lyons
    last modified by John Lyons
  • PowerCenter Data Integration 10: Developer, Specialist Certification

    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...
    Rupali Parab
    last modified by Rupali Parab