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!

  • Congratulations Mike Lewis 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. papagari

    Update Strategy

    Hi Cognos, Simple do this Up Str tgt ------ ----- amt(I,O)---------> amt(I) Lkp_Id(I,O)------> Id(I,PK) in the above in place of Lkp_ID, put src_id. Your Up Str contains 3 ports. amt Lkp_Id Src_Id Now Map like this Up Str tgt ------ -----...
  2. papagari

    help me

    Hi, If you are working on Informatica 6.1 or 6.2, You must have a network to your PC. Network means, it may be having Internet connection (cable or dial up). Then your PC recognises ip address. Put this ip address at host ip address during server registration in workflow manager. Then press...
  3. papagari

    errors in mapping

    You have to place your flat file in some directory in the Informatica server and not on your PC Client. And put the proper path and file name at sources and targets. This solves your problem. If you have further questions, let me know.
  4. papagari

    Update Strategy

    Hi, The only reason I could see for this error is: You might have mapped source id from Lookup port (this happend to be your target field) and not the one coming from source. So whenever your target source id is null, then you need to insert a row. It is inserting other data but source id. This...
  5. papagari

    temporary global table in Oracle and a new session

    Hi, I am really confused, I would give you a clear view about improving your mapping performance if I know exactly what are you trying to do with.
  6. papagari

    Informatica Certification exam

    My personnal experience is if you have good real time experience, it is worthy to think about it. Otherwise just ignore it. Since the examinations questions looks tricky, I advice a real time experience guys only to write. If you have, it is easy to write.
  7. papagari

    active and passive ??

    Perfect definition is: Active Transformation: No.of rows takes as input should be equal to no.of rows goes out from it as output. ex: Expression, stored procedure,... Passive: MAY not equal to ex: Filter, Router, Rank etc...
  8. papagari

    Partitions in Informatica

    Hi I would suggest to go for "pass through" partition and change sql query of each partition adding a condition in WHERE clause as ex. Account_key between 1 and 1000000 (for partition 1) Account_key between 1000001 and 2000000 (for partition 2) Account_key between 2000001 and 3000000...
  9. papagari

    How can I stop my workflow.

    Hi Narsimha, here it is right click on Session name -> press 'Edit' -> in propertie tab 4th is Enable test load - tick it and - 5th is no.of rows to test - type as 1000. then press OK. But wth this option you will not be able to check the data in the target table. You can manually stop the...
  10. papagari

    Installing Informatica Server on Windows XP Home.

    Hi You must configure your PC to use User name and password. And use the same username/password of your PC login during Informatica server installation.

Part and Inventory Search

Back
Top