473,545 Members | 2,085 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DB2 enabled Datawarehouse Pilot

We are currently implementing an enterprise datawarehouse using IBM
DB2. The Finance group will be the early adopter of the datawarehouse
via a focused pilot. There are three tables of interest for Finance:

Journal Map lookup table
Journal Detail lookup table
Journal Line lookup table

* Need to develop a user interface to maintain the Journal Entry (JE)
templates and chartfield assignment rules.
* A simple user interface will be developed to help maintain the flat
files more effectively.

I am looking for a reusable solution (or suitable pointers) that can be
leveraged to create, update and delete the values in these 3 tables.
The database records will be saved as a flat file that can eventually
be exported to the datawarehouse. Are there any off-the-shelf
solutions that are available in this regard? If not, we are considering
developing a simple database application to facilitate flexible journal
entry. Are there any off the shelf applications or reusable shareware
that can be adopted?

Are there any "Red Books" or other best practices that describe ERP -
datawarehouse integration?

Thanks for any feedback.

Jun 16 '06 #1
0 1126

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1642
by: Evan McPeters | last post by:
I need to develop an application that will run on an ipaq handhelp and possibly the Palm Pilot as well. Can this be done in python? Do I need a special library to make it work? Thank you.
1
1396
by: eric | last post by:
Hi there, is it possible to schedule processes on demand, for an external scheduler, not the one used by datawarehouse center - my company is willing to use only its official scheduler, that manages all our applications ? If so, what would be the best implementation for performance ? Thanks for your help, Eric
0
1384
by: Klemens | last post by:
What do I need to export datawarehouse center metadata and import it into rose? I exported the metadata in from datawarehouse center in CWM format. I tried to import these files using Rose XML Tools but with cwm.dtd from DB2 installation I get "Unknown element 'CWM:ModelElement.taggedValue'" After downloading dtd file from omg site I get...
4
2853
by: Colleyville Alan | last post by:
I have 2 command buttons on a form. I want the first one to be enabled and the second one to be disabled when the form is opened. That works fine. Then, after the user has pressed the first button, I want them reversed - button #2 is enabled and #1 is disabled. But I keep getting this error message: "You can't disable a control while it...
1
1708
by: Dennis Johansson | last post by:
I have a CheckBoxList like this one: <asp:CheckBoxList id="chkReport" runat="server" DataValueField="rptID" DataTextField="RptName" Enabled="False" RepeatLayout="Flow"></asp:CheckBoxList> I fill it with items from a database and check/select items corresponding to another database query. When first displayed, the user cannot...
7
2369
by: Noozer | last post by:
I have a timer on a form. It isn't firing at all. I know that the timer is enabled, and that the interval is low (4000, which should be 4 seconds). To ensure the timer wasn't being inadvertantly reset I put some extra code in the subs that enable and disable the timer. They fire as expected. To test this I added a second timer with a 1...
4
5945
by: Phill. W | last post by:
Here's a knotty little problem. I have some nasty little controls that needs to behave in a non- windows-Standard way - don't ask why; it's a large application being converted from some older code and my users are adamant that this behaviour mustn't change. Specifically, I want to be able to set myControl.Enabled = False
1
1387
by: prosanta | last post by:
Hi Is there any upper limit of size of Database of oracle for Datawarehouse application ? Best reagrds Prosanta
24
15043
by: indresh2152 | last post by:
what are Parallel approach & Pilot Approach in the implementation phase of the s/w development?
0
7467
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7656
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7419
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
4944
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3450
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3442
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1879
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1014
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
703
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.