Space: Developers
Skip navigation
Search support, knowledge base, training, discussions and more

Developers

Log in to follow, share, and participate in this community. Not a member? Sign Up!

Recent Activity

Sarunas Svegzda
Hello,   I have a INSTR function to find 2nd or 3rd occurrence of a defined string.   INSTR('My String','a',3)   Full push down optimization is enabled and i get an error:   expression [INSTR] with [3] parameters cannot be pushed to the database.   Is INSTR function with optional parameters supported?   If I use default INSTR function without… (Show more)
in Developers
Kamal Haria
Hi I have created a project and a profile rule in Informatica Analyst 10. Is there any way that I can use the same rule for different database, as I have 4 database, all having same structure but different data.   Thanks & Regards
in Developers
Stephane Cote
Hello   using SSA-name3 version 10.0 with international population file; person_name, UTF-8   the following are scoring scenarios; 1 shows the standard scoring and is correct 2-3 add a date and the results are not consistent because of the special o in the first name   Mônica Mendes de Queiroz de Moura MONICA MENDES DE QUEIROZ DE MOURA = 100%… (Show more)
in Developers
sanjitdas
We are publishing xml messages in TIBO JMS using Informatica JMS as target. In the JMS and JNDI the following parameters we provided plain text values and workflow is working fine.   JNDI UserName/JMS UserName JNDI Password/JMS Password   Q - Can we parameterize those attributes and read it from parameter file. Also can we use the encrypted… (Show more)
in Developers
Stephane Cote
Hello using version 10 with international population file.   If I search for "Van WEST" and doing a match   "JACQUES VANWEST" will score a 96% "ALAIN JACQUES VANWEST" will score a 94% "West" will score 94% "Van" will score 94%   I can maybe understand the first two; however how can I get a more accurate score on the second two.   merci… (Show more)
in Developers
Rafal Slapa
Hi , I was trying to do the tutorial and i am struggling to set up Infa. yesterday i was albe to login to the admin console page,created a repository service,integra services . Today when i woke up i got windows error msg that pmserver.exe stopped working and i could access admin page after that.   tried to stop all of the services and… (Show more)
in Developers
aditya nagulapalli
Scheduling a Job fails due to Error Time out issue. If run the Job it successfully runs it.
in Developers
nageena abdul
Hi,       I am using xml parser transformation in informatica power center 9.5.1. I have two files .xsd and .xml. while creating xml parser transformation i am importing .xml file. I am getting metadata like creation date,repository version etc in output groups of xml parser transformation instead of getting required column name. can anyone… (Show more)
in Developers
Mitesh Joshi
Hi Team,   We are doing a bulk load in SFDC. Suppose, when doing a bulk load, the SFDC connection gets lost/disconnected, and we have loaded almost 200k records by now. If SFDC rejects the record after connection is disconnected, where will be the reject file created or how we will come to know which record is being rejected.   Any help is much… (Show more)
in Developers
Dan Nichols
We are seeing an extra '?' character in date values enclosed in brackets [ ] within string fields when the field value is inserted into SQL SERVER.  The target field is VARCHAR.  This is happening at the INSERT step and NOT in the transformations (verified through verbose logging).    EXAMPLE: "At [1/23/2017 3:48 PM] Joe" from the final… (Show more)
in Developers
Load more items