Search results for query: *

Configuration has MaxSessions=10 this is number of parellel sesions, this value is the default. Can I change this value to 20, what are the effects?

How can I check for number sessions supported by informatica server?

I have a Worklet that has 6 sessions in it, this worklet trigers all the sessions at the same time. one of my workflow includes this worklet, when this workflow is trigred to start, some times everything prosses succesfully and some times, some or all of the sessions in the worklet fails, they...

I am using PC 7.1 and yes versioning is turned on, how can i overcome this problem.....

I tried running a session manually and it went through fine, but when I schedule to run it the workflow fails with an error "Failed to fetch session information from the repository in folder [folder name] for session session_name..... Unable to fetch mapping associated with session. Please...

When I try to edit Session parameter $PMBadFileDir\ to $PMBadFileDir\prod_dw\ When I close and open the session properties It takes a default directory name $PMBadFileDir\dev_dw\ Any suggestion how I can change this directory name and why is this taking a default directory? Is this any thing to...

Using PC 7 how can I save the last run date. My functionality is to use the last run date for the next run and get the data based on that, how can I achieve this. How do I use the parameters for this, and how can I assign the last run date to the parameter.

I am using pc 7.1. I have a string "abcd efg hijkl mnop qrst uvwxyz" I need to find out if string "hijkl mnop" exists in the above string, how can I achieve this using PC, is there a function for such a operation. Your comments are highly appreciated. Thanks

Can there be another bridge tables whcih can be used to handle this or are there pros and cons following this procedure if so please can you elaborate on this ..??

Thanks All for quick responses, Yes it's essentially coming from the sourcesystem and not being generated in the ETL stage , Our goal was to do reporting of what is available on sourcesystem and not responsible for cleansing of the data.

From the staging tables we are planning loading the fact , but we are having duplicate entries which would essentially break the summaries for reporting.. Did anyone who has undergone the issue would throw some light would be glad?/ Thanks, Info

How to handle multiple dates in the fact table, should thisbe set as foreign key to the date dim table .Any help on getting me to know the efficient design would be highly appreciated... Fact---- date1 date2 date3 LineItem

I am using PC 6.2. My mappings loads data from a flat files to Oracle database. File size range from 1 record to 1,000,000 records, most of the times file size will not exceed 10,000 records. I am caching two tables, one cahing 4,000,000 and other 1,000,000 records. For any given file though the...

I would like to know if PC 6.0 can handle Japanizes Kanji scripts. If yes, do I need to make any setup changes, like ASCII or Binary, I am not sure what my current setup is. The other question is, if it can handle Kanji, can it handle regular english or both have to run separately .

I am planning on moving an entire folder within a repository into a different Reposatory. Can some one suggest which is the easiest way arround it.

PC 6.0 I have two different repositories A and B both are identical in terms of folders both have X and Y folders. The only difference is A has versions A:X 1.0.0 and A:X 1.1.0 A:Y 1.0.0 and A: Y 1.1.0 B:X 1.0.0 and B: Y 1.0.0 I have some mapplets in A:X 1.1.0 that are used by mappings in A: Y...

I am trying to use the same mapping for several sessions in several mappings. My question is if all the workflows are started together, will this impact the performance. can some suggests me if it is advisable to use same mapping for several sessions. When should I switch between multiple...

If u want to invoke informatica workflow from PMCMD command and use parameter file name with path as a PMCMD parameter, In my session properties, if I pass just file name will it work (not full path , just file name) How can you use the parameter file when invoked from command PMCMD).

Can I achive this, I do not want to give the parameter file path within my informatica session, just pass the parameter file name. If I pass the parameter file path and name form PMCMD command, can my session automatically get the parameter file path. Here is the command I am using...

I would like to know if I am correct all I did was two sessions one to build persistant cache second to use the persistant cache in my first session lookup, I enabled "lookup cache enabled", enabled "persistant cache" and gave a "cache file prefix name" as "tempcache" in my second session...