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

    estimate datamart space

    Blom, I have to build the datamart. It only contains 8 tables. It's an Informix datamart. I have the tables ready and have loaded with data. But how do I do the sizing estimate for the whole datamart. Is there some kind of calculation or do I have to analyze on how my data is growing? Thank you...
  2. dbatlanta

    estimate datamart space

    hello all, I have to allocate space for the datamart. But I am not sure how to. Any insight is really helpful. Thank you.
  3. dbatlanta

    incremental load using mapping variable

    Hi All, I want to use mapping variable to do incremental load. The prob is my source doesn't have any date columns. I tried putting sessstarttime as loadtime and used a lookup to look for the sessstartime and load new data based on it. But this logic is not working. Basically I want to...
  4. dbatlanta

    mapping variables and parameters

    Hi All, I need some help with some information on mapping variables and parameters. I have read the manuals and I know theoretically what it means. But could you give me an example of where I would use it best. And where do I store the parameter file? Is it in the Informatica Server? I...
  5. dbatlanta

    insert new rows?

    Ties Blom, I created the target table in Informix. I only need to extract some of the columns from the source DB2/AS400, so I created the table in informix using these limited columns. And then I loaded from the Source to the target. I am not sure how exactly I should be creating the PM key...
  6. dbatlanta

    insert new rows?

    I have a source in DB2/AS400 and target in Informix. The source doesn't have any PM key or any unique key. All the columns contain dublicate datas, or it is not unique. I want to implement incremental load for the target table. But I am not sure on how to implement this since nothing in the...
  7. dbatlanta

    error because of constraints

    Hi All, I have a source in DB2, and my target is Informix. The tables have the same columns,datatype,PM keys.I have used a lookup to lookup the two unique columns from the target which has the composite PM key. And I am using a filter to filter only the new data based on the lookup. I did some...
  8. dbatlanta

    using command task for post session email

    I am trying to send an email to myself after the workflow is successful/unsuccessful. I read in the Informatica manual that I can use a command task to include an email task in the workflow. I know how to create a command task, but I don't know what unix script I should be putting to send an...
  9. dbatlanta

    Target pre and post sql

    I need to delete three days(sysdate-2, sysdate-3, sysdate -4) data from my target table. Then I need to update three days (sysdate-3,sysdate-2,sysdate-1)data from the source table. How do I accomplish this? Is there a way to use the pre sql in Target properties to delete rows for three dates...
  10. dbatlanta

    DB2 connection issue

    I am trying to import a DB2 source. But I am not seeing any tables even after I have established connection with the DB2 server, port no.,with the right logins. Am I missing something? The source I am trying to pull is in production. What reasons can there be for me not to see the tables when...

Part and Inventory Search

Back
Top