Search results for query: *

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 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

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 how I can use persistant cache. Here is what I am planning on doing, I am planning on creating a session that would referesh the cache and a following sessions use this cache. First session would referesh the data form the database and all the following sessions just use...

I do not want to cache lookup table data, I tried disabling the cache in my lookup tr, I am getting an error saying that this is not yet supported by informatica. I would like to know If I am doing anyting wrong. Here is the scenario, I have a source with 20 records and my lookup is caching...

Can any advise me how can I include a session variable that can be passed in as a source file directory path. I know it can be passed as $InputFileName=/fullpath/file_name but I do not want to combine path and file name together. I want path as a saperate variable and file name as a superate...

I would like to know, how we can pass a dynamic source file name and server path. I know it can be done using a parameters file. Can some suggest me how, and can you send me a sample of the parameters how I can use them. if possible send me a sample parameter file name with parameters. Thanks...

I would like to perform a UNION within informatica 6.2, I know there is no transformation to handle this in Informatica 6.2, but is there some kind of logic to handle this. Again my source is a flat file and I have to modify the data before performating this union.

Can come one advise what could be a side effect of increasing the commit interval from 10000(default) to 40000. If there is any please let me know. I am trying to improve the session performance, that is the reason of increasing the commit interval.