Log in to follow, share, and participate in this community.
Not a member?
Sign Up! Hi Gurus, I had a question regarding Informatica admin console access in multi node domain environment . We access the admin console using IP address which is the IP of the node which host the domain, i... Failover in multinode domain
BackHi, I have a requirement to read ID's from CSV file and generate an IN clause out of it and use that in my SQL where condition For example: CSV file: just one column ID abc xyz lmn... How to Create dynamic param file using CSV file as source
BackHi, when i try to run a mass ingestion job where source is my oracle db and target is CDP hive connection. i get the below error message. would really appreciate if i can get a solution to this error message.... I'am trying to do Mass ingestion of two tables from idq to DQR datahubin cloud connection. My source connection is oracle database and target connection is HIVE. when I try to deploy the job i get the below e... Hi my requirement is to populate the records from a table to flat file and then at the end of file need to attach a footer that would have one field as fixed value and other field should be no of records in t... count of records from DB table
BackHi , My database will be move on Netezza to Azure sql sever .currently I am using Informatica data quality 10.1.hotfix 2 and it will is not moving on cloud. Could you please let me know, How will I con... Netezza database move to cloud Azure SQL sever but Informatica data quality 10.1.hotfix 2 not .
BackHey All, Need feedback from experts. We have Informatica 10.4.1 recently upgraded. Running on Linux 7. There is Oracle database 19C behind. The version of Apache Tomcat 7.0.103.0, and has been flagged a... Informatica 10.4.1 and Apache Tomcat 7.0.103.0
BackHi Folks, I have a requirement where i do want to parametrise the expression transformation columns with day-15 and day-1 date. For Ex:- Expression Transformation ColumnName &... How to parametrise expression transformation columns
BackHello Folks, I need a help , my requirement is to find the missing dates between the Range of dates for e.g Created_dt 2020/09/11 2020/09/10 2020/09/08 2020/09/07 2020/09/05 So if my date ... Finding Missing Dates Between range of dates
BackHi, I have a scenario where I have to update the salesforce object . Suppose, we have 3 External Id fields-A,B,C. Then how Informatica would know on which Id, it has to update the record as I have defined thre... How to Update the salesforce target with multiple external Id in Informatica
BackI have a simple maven project to do some SIF calls with MDM hub, and added siperian and castor dependencies for this. <dependency> <groupId>informatica</groupId> <artifactId>siperian-api</ar... siperian-api.jar unable to find castor.XML.getResolver method
BackHello All , We are planning to migrate the Informatica application to ADF . for that we need the current details like how many redundancies are there in the workflows /Mapping /Session etc in all the folders ... Informatica repository redundancies
BackHi All, I'am facing this strange behavior in Informatica developer 10.2.0. I have a mapping that has a filter before the FFDS target with filter condition " OUT="NO" ". So, my code was expected to write the ... empty file getting generated in informatica developer
BackHi, Am trying to enable GIT versioning control system in Infa PWC 10.2.0, Model Repository service for versioning concept. But while configuring New MRS i can see only Perforce and SVN under HOST ... Hi All , Question :Suppose Source have 1 billions of records and after loading 50K records session got failed and when re-run the job it throwing Unique constraint error .How to solve ? My answer : It's... i want to schedule my workflow(wf_abc) with 2,5,10 or any number n sessions present. lets take 5 s1,s2,s3,s4,s5 requirement in that i want my workflow(wf_abc) daily but one task one day i.e today s1 then on next day ... schedule workflow daily and each task one by one day
BackHello All, We have a legacy workflow which needs a change now, and when trying to identify which host the Connection String points to, we are unable to find the declaration of 'CONNECT STRING'. It is a relatio... Different methods to create a ODBC String
BackHello All, We have 7 different workflows, each with 4 to 6 sessions which are all triggered manually after the successful completion of each workflow. We need to set the dependency in such a way that wf2 start... Setting Dependencies between workflow
BackHi, I would like to join around 10 tables and write to the targeted table. I'm using Joiner transformation, I need to create 9 joiners in order to achieve it. I would like to ask the experts here, any other o... I have a lookup table (lkp_general) and a customer table (customer). In the customer table consists of columns: - CustID - Name - Gender - Country - Race - Occupation While lkp_general consists o... Unconnected Lookup with condition
Back
