• Repository query to get the lookups and corresponding connections used in session

    Can anyone please help me with a Informatica repository(Oracle) query to extract all the session names, lookup instance names, connection/variable names. PS- Informatica PowerCenter 10.4
    Rajesh kumar Mahapatra
    last modified by Rajesh kumar Mahapatra
  • How to Enable Debug Log in Informatica MFT

    Open video

    Arun Som
    created by Arun Som
  • How to Add Permissions to the User on all the Folders in PowerCenter Repository

    Open video

    Arun Som
    created by Arun Som
  • How to Create a Data Processor

    Open video

    Arun Som
    created by Arun Som
  • Import Tables from RDS Oracle DB

    Hi,   I am attempting to import tables from an RDS Oracle Database into PowerCenter 10.4.1 (Datadirect 8.0 Oracle wire protocol) but without success.   Can anyone advise how this can be done?   Many ...
    David McCoy
    last modified by David McCoy
  • Migrating to a new DB

    We want to migrate to the Oracle 19 for our repository DB. (We would be running 10.4.1 at that time). What effort will it take from an informatica stand point? Have the Oracle team to change the TNS entry, and copy th...
    John Lyons
    last modified by John Lyons
  • How to read multi tagged elements from XML Source

    Hi,   I have the following XML source file (I just put a portion of my XML source file here and not the entire content due to size).   I have created my denormalized XML source using the raw XML file and ...
    Mani Ar
    last modified by Mani Ar
  • mapping logic

    Hi,   i need a mapping logic for the below scenario to find the exact match partial match strings.   condition all the records in Table A must exist in Table B   Table A   COLA  COLB COLC ...
    EC137656
    last modified by EC137656
  • Error - [DOM_10080] Cannot start service [dev] because there is no process enabled or there is no node available for this service. Verify that service processes are enabled and nodes are running on the domain.

    Error  - [DOM_10080] Cannot start service [dev] because there is no process  enabled or there is no node available for this service. Verify that  service processes are enabled and nodes are running on t...
    EC132619
    last modified by EC132619
  • Sessions with truncate target table option checked

    In the session settings, on the mapping tab, when highlighting a target table, there is a checkbox that says "Truncate Target Table Option."   I would like to query the repository to find all sessions where this...
    Bryan Mack
    last modified by Bryan Mack
  • How to Send Rejected Files as Email Attachments in PowerCenter

    Open video

    Arun Som
    created by Arun Som
  • steps need to be taken care of after we change trust score for a column

    Hello folks,   We are planning to change the trust score for one of the columns for one course. can you please suggest me what are the steps needs to be done after or are there any batch jobs that we should r...
    inuser493428
    last modified by inuser493428
  • process to export mapping from informatica developer to powercenter

    store procedures  called in Mapping are being replaced by API. Now I need to call API in mapping. For this i have created a mapping in Informatica developer where i used web consumer  transformation to use ...
    Rishika agrawal
    last modified by Rishika agrawal
  • 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
  • Workflow Schedule Not Working for Next Schedule Run

    Hi All,   I Have some issue, actually after my Informatica Upgrade to 10.4.1, some of my workflow is not working for next schedule run. Let say I have 16 workflow, All workflow is run every 5 minutes, but after...
    Ilvan Faozan Arief
    last modified by Ilvan Faozan Arief
  • How to start with PMCMD

      Hi Team,   we have a informatica 10.4 setup in windows environment and we need to start using executing workflows using PMCMD commands going forward and need help how to start with.   Do i need to c...
    SP K
    last modified by SP K
  • How to Perform Indirect File Load using Informatica PowerCenter

    Open video

    Arun Som
    created by Arun Som
  • 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
  • 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
  • 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