Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

DW model for Retailbanking

DW model for Retailbanking

DW model for Retailbanking


I am looking for a conceptual model for Developing DW application (Retail banking)..

Any step-by-step approach available as to what exactly may be the requirements in a Retail Banking (framework)?

Can anyone help me out? Any document available on the net?



RE: DW model for Retailbanking

First of all look at the systems being employed in your organisation and their functions. You'll find the different systems from client facing (accounts, loans etc) to back end (reconciliations, .

(very important bit..)
Then go and talk to the business and get them onside - you'll need strong business leadership who really want to data warehouse.

Build a matrix (on paper) with your business processes down the left hand side and possible dimensions (i.e. entities that you could analyze by - date/time, client, account details,loan details, location amongst others) along the top. Then check the boxes for each matching process/dimension so you end up with a consice view of the business. Take this back to the business users (or develop it in conjunction with them.

You can then start your analysis and design phase.

hope this helps


RE: DW model for Retailbanking

I used to work for NCR, and they sold a retail banking data model and were capable of providing consulting to go with it.  Of course they would then try to sell you teradata :)

But the data model was not teradata specific as I recall.
I wish I could give a contact... but alas I can't.
I bet you can find a contact if you poke around on their website tho.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close