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 SkipVought 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: *

  • Users: OraBalz
  • Order by date
  1. OraBalz

    Parameterize the schema name of tables in INFA 6.2

    Can anyone tell me how to parameterize the schema name in Informatica. I have a parameter defined in Parameter file for the Database connection. In the same database, I have tables from many schmeas to be used in an INFA Mapping. Rightnow, I have hardcoded the Table Name prefixes in...
  2. OraBalz

    Invoke Java APIs from Informatica

    We need to invoke Java APIs using Informatica. If anyone has idea on the same, please let me know. Thanks in Advance
  3. OraBalz

    Connecting to ORACLE database from Informtica

    I am trying to connect to Oracle database from INFA. The connectstring /TNSName is 'swm1_rs242m'. I tried tnspinging from the Unix box where the Server resides. tnsping swm1_rs242m. It is connecting to. I have created a Database connection in Server Manager with the conenctstring swm1_rs242m...
  4. OraBalz

    converting date to integer

    You can specify the Date format in the way you need your ouput to be. Foe eg. if you say TO_CHAR(SYSDATE,'yyyymmdd') then you will get 20040420 as output.
  5. OraBalz

    Passing 'SESSSTARTTIME' in PreSession command?

    In the PreSession command, can I pass the 'SESSSTARTTIME' variable. In my PreSesion command, I am calling an Unix script which needs this SESSSTARTTIME as inout. So if I could specify the SESSSTARTTIME in my PreSession properties, my Unix script would use that value. Any idea on the same... TIA
  6. OraBalz

    INFA Session - Connect String for Paradox

    I am trying to run a Session by sourcing the data from paradox. The Session fails because of ODBC error. I have defined a ODBC connection to import Paradox Sources into my Source Analyzer, which worked fine for some tables. Now I am trying to run a Session with the imported Paradox sources...
  7. OraBalz

    Max. Length of Mapping Name in Infa 5.1

    I need some info on Infa 5.1 Is there any restriction on the length of Mapping Name in Infa 5.1. What is the maximum length that Infa allows for ETL Name. TIA
  8. OraBalz

    Q on Negation operator in Informatica

    Is there any negation operator in Informatica, which could be used in the following scenario. My requirement is that if the value of a variable is say -5 then make it as +5. Using the 'SIGN' operator I would be able to identify if it is '-5'. How to implement the next part, if it is '-5' then...
  9. OraBalz

    Soucing from Paradox Database

    We need to source some data from Paradox database into our DW. Using Informatica, would we be able to connect to Paradox database? If anyone has worked with similar sourcing please help me out. TIA

Part and Inventory Search

Back
Top