Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kpmINFO

    Execution treminated unepectedly.

    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?
  2. kpmINFO

    Execution treminated unepectedly.

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

    Execution treminated unepectedly.

    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...
  4. kpmINFO

    scheduling

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

    scheduling

    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...
  6. kpmINFO

    Session parameter

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

    Parameters

    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.
  8. kpmINFO

    SUBSTRING

    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
  9. kpmINFO

    Multiple date values in fact

    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 ..??
  10. kpmINFO

    Handle Duplicate enteries in Fact

    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.
  11. kpmINFO

    Handle Duplicate enteries in Fact

    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
  12. kpmINFO

    Multiple date values in fact

    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
  13. kpmINFO

    caching

    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...
  14. kpmINFO

    Handling different scripts

    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 .
  15. kpmINFO

    Folder Move

    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.
  16. kpmINFO

    versioning

    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...
  17. kpmINFO

    Reusable session

    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...
  18. kpmINFO

    parameter file

    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).
  19. kpmINFO

    PMCMD, Parameter file

    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...
  20. kpmINFO

    Persistent Cache

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

Part and Inventory Search

Back
Top