to follow, share, and participate in this community.
Not a member? Sign Up!
We are having issues with setting up our SPN's for our Enterprise Data Catalog installation. i need someone to validate the script and if I need to do anything on my AD account i'm using this query againsts the IDQ repository to find all my SQL Overrides for READ and Lookup Transformations Does this do the trick. It seems to find READ but i don't think its pulling from Lookup. select PO... Hi i haved this error, Message Code: HIER_28056 XML Reader: Error [ExpectedCommentOrPI] occurred while parsing:[FATAL: Error at (file EMPTY, line 73, char 1 ): Expected comment or processing instruction.]; line... Hi, Here is the problem statement where we need a resolution. We have an IDD application dealing with Customer data. The proper subject areas have been created and it works fine. But we are facing one pr... @ I have a scenario wherein regular expression is to be applied on a few source columns based on the country. I created a managed reference table in Informatica Developer with two columns Country code... Hello , Recently our database has migrated from an old server to a new server. But there is no data in repository tables , and maily we are concenered with REP_SESS_LOG. Can you please help us troubleshoot... Scenario I am facing is we have couple of records coming from source are having duplicates. we have a composite key [ID1 and ID2] defined at the informatica level and not at the DB level. let's assume there are two re... Hi Experts, Hope all are doing good!! I would like to know the key differences between Informatica PowerCenter and Data Quality. Also, What are the additional features/options present in Data Quality ove... I have a requirement where I have to check for a Control file when the workflow is executed. If the control file is present then run the session. If not wait for 30 minutes. Check again after 30 mins. If still the con... Hi all, Can someone please advice how to setup Athena JDBC connection in informatica 10.1? I downloaded v2 driver from Using Athena with the JDBC Driver - Amazon Athena Put in in my jar directory set... Hi All, we are recently migrating from 9.6.1 to 10.2 informatica PC with SQL server as application database i am facing two issues actually 1) for one of the mapping where we are getting error as , value too... Hi, I have a CLOB column in the source which is having character > 4000. While loading the data into varchar field(4000), I used the below logic: TO_CHAR(SUBSTR(COLUMN_NAME,1,4000)) still, there ar... Hi I would like to configure my Admin console url into an alias name. Can we do it in Informatica? I do not want the url to have server name on that. or do we need to take help of any DNS te... Hello, I currently have a Get API process that is retrieving orders with data such as order number and customer name and then doing a POST API call to another application. However, I would like to do store eac... Hi All, Thank you can Informatica cloud IICS read parquet files? Also, see whether Informatica can derive the column names automatically from parquet files. Another one is whether Informa... Hi Team, I have a scenarios, I have to read a file daily " File_Name_date.txt " load to Table. Same Date file may come multiple time in a day so If the same Date file process again then i need to Delete all the... Hi Team, How the frame work will help for a desgn in informatica, Can i have some frame works that may help full for the project for a specific requirements. Thanks spk Hi , I have the below data and i would like to populate a column as shown . In a group , first record should get compared with all other records and relationship with other records should be stored in output column.... Hi , I have below data and want to get the output as given below , please help. Source Data CUST_ID GROUP_ID 101 1 102 1 103 1 104 2 105 2 106 2 107 2 108 3 109 3 110 3 111 3 112 4 113 4 114 5 ... Hi Experts, Hope all are doing good!! I would like to know the key differences between Informatica PowerCenter and Data Quality. Also, What are the additional features/options present in Data Quality o...