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

  1. reachbgk

    R6 Database Template

    I have Notes5 Domino server at work. I got a Notes6 client CD from a friend. I installed R6 client and it is running on R5 domino server. My friend has R6 domino server and R6 client. His Inbox interface is a little different than mine. His has buttons for 'New Memo' etc and mine does not show...
  2. reachbgk

    "Create Picture" does not work

    I have Lotus Notes R5. I want to insert an animated picture in my email. When i click on 'Create' - 'Picture' i get a msg 'Import/Export' not configured. Help please
  3. reachbgk

    Cannot start from a session in a seq batch

    i have a sequential batch of 7 sessions. In the past i was able to start from any session within the seq batch. I would start the batch from the 3rd session and after the 3rd session a completed, the 4th would automatically start and so on. All of a sudden that stopped working. Now i can start...
  4. reachbgk

    rejected rows, notifications ect.

    My source in this case is flat files. The rejected rows go into exceptoin table. A report is sent to the users showing why the rows were rejetced. The users prepare a file with only the corrected rows (in the same file format as the original file) and send it back to us. We then reload the...
  5. reachbgk

    ETL Architecture

    Try to use connected lookups. If possible cache your lookups. If you are using uncached lookups, make sure you have a index on the lookup column.
  6. reachbgk

    rejected rows, notifications ect.

    1) For the rejected rows - i normally put it in a exception table with an indication of why the record was rejected. You can output the rejected rows to a file too. The advantage a table ahs is that my users query the exception table and can look at how many rows were rejected and why. 2) I...
  7. reachbgk

    Web page for load status

    I want to build a website for my datawarehouse project. On the website i want to show the status of the various loads going on, how much data is loaded, what completed, what errored out. Right now the business users keep calling the developers to find the status of loads. This webiste would...
  8. reachbgk

    Data Modelling Tool

    I want to build a data model for my datawarehouse. My company has an enterprise license for a data modelling tool but that is just for the DBAs. We developers are not allowed to install it. I want to download some tool that will help me build a logical data model for my own reference. I know i...
  9. reachbgk

    Query informatica repository for metadata

    I want to build documentation for my informatica mappings that can be used by business to understand the details that go on in the load process. eg process selects data from xyz table, then applies a filter, then performs lookup against a,b,c, tables. I can do this in visio or any other...
  10. reachbgk

    passing results from one data provider to another

    What i mean is that DP1 returns a list of customers who have made reservations. I want DP2 to return more facts about those customers. So i want to limit DP2 by the customers returned in DP1.
  11. reachbgk

    passing results from one data provider to another

    I have a report in which i have 2 sections. There is a different data provider for each section. So, i have 2 data providers i.e DP1 & DP2. I want to pass results of a column in DP1 to the DP2. I know i can do that by including a subquery in DP2 but i do not want to do that as DP1 queries...
  12. reachbgk

    Comparing two Fact Table Data

    I have a similar situation in my project which is on oracle. I have a fact table in which i store activities performed by salesreps. A new requirement has come in to store the activites that were planned for the rep and then produce a report comparing the planned activites against the actual...

Part and Inventory Search

Back
Top