• 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
  • 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
  • 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
  • Informatica most recommended way for Oracle HA

    Hi Team,   I have informatica Powercenter v10.5 installed in lower environment. I wish to have HA for Informatica in Higher environment. I have few DB users available in my Oracle used for installation and Loadi...
    inuser526279
    last modified by inuser526279
  • Automate bulk Check-in or undo Check-out

    Hello Infa Experts,   We're in process to cleaning up our Informatica Power Center repository. I was going through all the repository tables and was wondering if there is a way to update directly the repo table...
    Rex Wayne
    last modified by Rex Wayne
  • Russian character loading issue

    Hello,   We have to load a table with Russian characters from SQL Server to Oracle target. While loading we noticed that the byte length is increasing for russian characters, For example - if the actual length i...
    Arun Kumar
    last modified by Arun Kumar
  • IICS Primer for PowerCenter Developers

    For years, Informatica PowerCenter has been the gold standard for on-premises data integration. For many companies and organizations Informatica PowerCenter, together with an enterprise data warehouse, has served as t...
    Rashmi Rekha Gogoi
    last modified by Rashmi Rekha Gogoi
  • Fixed width header, trailer and data

    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...
    Arya Nymeria
    last modified by Arya Nymeria
  • extract date and time from timestamp

    How do I extract date and time values from timestamp and store them into separate columns? Thanks! I tried TO_DATE(TO_CHAR(TIMESTAMP_VALUE,'YYYY/DD/MM') but that doesn't work....
    J Dos
    last modified by J Dos
  • Find whole number and decimal and pad zeros.

    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...
    Arya Nymeria
    last modified by Arya Nymeria
  • PowerCenter 10.5 release date

    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
    user151735
    last modified by user151735
  • Same source and target table to read and update? Can we?

    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...
    Arya Nymeria
    last modified by Arya Nymeria
  • Read and write to the same table? Can we?

    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...
    Arya Nymeria
    last modified by Arya Nymeria
  • Shell Script to move files from Infa_shared directory to another server

    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 ...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • How to handle comma and double quotes in data for a .csv output file

    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...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Please help scenario

    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...
    Arya Nymeria
    last modified by Arya Nymeria
  • Wf Scheduled to run 10 times Monday to Friday

    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...
    SP K
    last modified by SP K
  • JSON Target File on PowerCenter Standard Edition - 10.4

    Hi All,   In Informatica PowerCenter - 10.4., I need to create output file in JSON Format. Can anyone let me know what are all the possible ways to create JSON Format Output file ?
    R R
    last modified by R R
  • old mapfwk API does not recognize type "Timestamp"

    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...
    Etienne Aglas
    last modified by Etienne Aglas