to follow, share, and participate in this community.
Not a member? Sign Up!
How to open a mapping in read only mode ? I am trying to bring up the informatica service but am getting below error Node.log 2019-11-29 05:20:36,564 ERROR [Monitor Guaranteed Message Logger Thread] [CCM_10322] While logging messages to the Log Servic... I have a mapping that ran pretty fast up until today. Seemingly now when I execute it, it runs the mapping for an unlimited amount of time. Can anyone explain why my mapping would either randomly stop working or incur... I don't have any experience on any ETL tool. However I want to know if it is possible to do the followings using any ETL tool or we need to write a java or any other batch job to do this: Scenario 1: Th... Can we connect to workday using Informatica power center 9.5.1 and using http transformation. When we are trying to connect using http transformation calling a https url of workday, we get below error - Messag... I want to upgrade from Informatica 9.0.1 to 10.2 and I Installed windows 2012 R2 initially and copied previous version folder to new machine for upgrade.When I start the installation of Informatica 9.5.1 this gives er... I am wanting to create this new column which is a boolean. It will return a "Y" if the conditions are true and an "N" otherwise. A condition is true depending on certain columns: Date_column has to be ... Hi, I'm new to informatica admin. What are the tasks needs to be taking care by admin? Could you explain on this? Thanks, Sankar My source table looks like: Col_1 Col_2 1 F 2 S 3 A I want to generate a target that has all possible combinations of values from column Col_2 and add a surrogate key. The target should be like: SK Comb... Hi All, In my mapping I have a sequence generator which passes the nextvalue to 3 different targets via an expression transformation. But I can see the value in only 2 targets(table) and in one more target ( ... Hi, I designed an informatica mapping which will extract the data from .txt file and load into oracle table. This process is working as per the expected. I would also like to know and store how many re... Hi, Powercenter Integration service goes down frequently. and below is the error message I get every time. Same error was available in node.log as well. Powercenter GRID ... HI Team, Getsession log for an worklet works fine if we ignore the worklow run id or instance name parameter. infacmd.sh getSessionLog -dn name_of_domain -is integration_service_name-rs repository_name... Multiple files are to be loaded into their respective tables . Both files & tables have same schema/format, only file/table names are diff. Each field inside has same name,ordinal position & data types. Used I... Hello, I have a weird problem. I developed a mapping that reads data from an xml file and inserts it in a flat file. My mapping works well but when I remove a specific tag, the mapping doesn't generate the f... Hello Folks, Could someone help me with the below requirement? The naming convention of our SQL server DBs are <DB_Name>_<Current_Date>. We have a rule defined at DB level to automatically create a repl... Hello, Some data is being truncated (warning FR_3015) in my reader. But I've checked and I'm sure of the datatypes I've specified (string 14). I've checked the whole mapping for precision issues but I can't fi... Hi All, I need one help regarding Web service consumer transformation my requirement is as below I have to consume two web service(SOAP) the first one will give the token as output and that token i need to... Eva/Niraj/All, I am working on Informatica 9.5.1 at work and interested in pursuing Informatica Developer Certifications. Can you please guide me on the following related to PowerCenter DI Developer specialist certif... Hi All , Currently we have Informatica Production Environment which is already live and we are planning to have the DR set up now. https://network.informatica.com/message/13604#13604 I am planning to have t...