Search results for query: *

Problem Statement: What are the steps to upgrade Informatica Power Center (PC) v6.1 repository to Power Center v7.1.2 repository? Description: We wish to evaluate upgrade issues that will arise when we migrate to v7.1.2 from v6.1 before we migrate our environments. We want to migrate a PC...

Hi Ties Blom, Thanks a lot for your valuable reply. I looked the views suggested by you. Is there a way that this repository will not show all the mappings from a particular repository? I am looking my TEST repository but I can not find all the mappings from a particular folder. Thanks, Roopali

Are you using yahoo IM when you have starts debugger? Yahoo IM uses same port, so log off and you should be set. Somebody told me this trick and it worked for me. -Roopali

Do you have an query OR relationship among repository OPB_* tables, which can provide information on "Source Table Name-Mapping Name-Target Table Name' from Power Center v6.1 repository? The Metadata reporter gives information session by session but I want to view directly like excel sheet...

You can write SQL in the Relation Connection Object under 'Enviornment SQL'. This wont allow informatica to invalid your SQL. The only disadvantage of this that you need to have specific connection object for this Lookup SQL. The other solution of creating a view also works well but you may...

Hi, I am using Power Center 6.1. I have mapping to load a FACT table. 1) In the mapping, I am using Dynamic Lookup (Lookup Data cache size = 2000000 and Lookup Index cache size = 1000000 (defaults)) to check if the record is already existing in the Target table. 2) If the record exists then...

Hi Eric, Thanks very much for the tip. After logging out from IM, it works now. Thanks, Roopali

Hi, I want to send email from excel macro. I have registered MSMAPI32.ocx and have included the MAPI in components. I dont have any form but there is some calucation on the excel which will trigger this email alert to production person. When it goes to first line mapisession1.signon, it gives...

Hi, Whenever I start the debugger on my machine for a mapping then I get following error. I have Windows XP professional operating system. Establishing a connection to the server ljcms651... Server ljcms651 acknowledged its ability to debug a mapping. Initializing debugger... bind...

Hi, Right now some of the challenges we have with persistent values (parameters) for ETL sessions. Please let us know if you have any information on following points 1) To Set Persistent Value: In our workflows, the persistent values are defined at session level. Each individual session uses...

Hi, Have you worked with Teradata Tpump for loading data from Informatica power center 6.1? I am looking some inputs in terms of 1) what are different way to improve load performance using Tpump for informatica sessions? 2) Is there any optimal number of 'Pack' setting for Tpump? (for...