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

    Issue with running command task on PC 8.1.1 sp2

    Thanks for the reply. We have 6 repositories in our test env.Till version 7.1.3 , we had individual .param file and .cfg file for each repository and we had the priv to run same work flow in different repositories at the same time. Basically each repository had a connection to its own target...
  2. vicsap

    Issue with running command task on PC 8.1.1 sp2

    I have recently upgraded from PC 7.1.3 to PC 8.1.1 sp2 on HP-UX box. I ran some workflows containing session tasks and those ran fine. Currently I am having problem in running command tasks. We have some perl scripts sitting on Unix box and the command tasks call those scripts and run those. We...
  3. vicsap

    Error while dropping index

    Thanks for the reply Varc. Can you please translate the same in English as I don't know Spanish. Thanks
  4. vicsap

    error in even logs of server

    Try pinging to the server.
  5. vicsap

    Error while dropping index

    I am trying to drop index using: DROP INDEX Bill_Cycle_ID ON BI_DM_7.Snapshot_Revenue_By_Bill_Cycle; and I am getting the following error message: 6952: Indexes cannot be created or dropped during random AMP sample emulation. I have never seen this error message before. Please advice
  6. vicsap

    Informatica- Teradata Version

    Hi all, Currently we are using Informatica 7.1.3 and Teradata V2R5.2 . Now a days we are in process of upgrading our Database to V2R6.1. But we have heard that Informatica 7.1.3 doesnt support Teradata V2R6.1. I am not really sure about it as we haven't encountered any issue in testing so far...
  7. vicsap

    Functional testing in Informatica

    I agree with Ties Blom . Most of the places we use staging area or something called staging tables built in the target warehouse only. But most of the times these staging tables have one-to-one with their corresponding source tables. Therefore most the validation will be done on target...
  8. vicsap

    Functional testing in Informatica

    One of the way , you can make sure that the data is correct by writing some SQL queries to make sure that the data loaded in the correponsding tables is in accordance with the business rules defined in the mapping. I havent heard of any functional testing tool for Informatica.
  9. vicsap

    Error in Starting Workflow

    If you are running Informatica Server on windows based machine, another place to check is to make sure that your Oracle Services are also up and running before your start your Informatica Server
  10. vicsap

    Rollback in teradata SQL assistant

    No, you cannt explicitly rollback in Teradata. You can set it specifically while using BTEQ ,where you can use Begin Transaction (BT) and End Transaction (ET) commands. Hope this helps

Part and Inventory Search

Back
Top