to follow, share, and participate in this community.
Not a member? Sign Up!
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 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 ... 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... 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 ... 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 ... 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... 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... 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... 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 ... 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... 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... 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... 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, ... 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... 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...