Model Customer Transactions with variable tax counts and amounts

Customer Dimension

I am trying to model a Customer Dimension with Educational and Employment details and I want some advice on how to model this scenario A Customer can have several levels of Education like schooling, college, university, training (one to many realtionship

Addresses in Customer Dimension

As part of an Orders dimensional model, I am attempting to design the Customer Dimension table. The customers have multiple sold-to addresses and multiple ship-to addresses. While the OLTP allows any Order to have any combination of sold-to and ship-to

How to create transactions SCD2 from many SCD tables

Hello, During the design of a HR data mart I had a problem that was repeated in every dimension: All the dimensions are SCD type 2 and their sources are few operational tables that each table has a history records. For example: Dim Employee is buil

Monster Dimensions

My customer list is huge (about 70 millionish). We currently have a 60 million row dimension (CUSTOMER) that holds most of our existing customers, and this existing large DIM is currently performing fine for us. Now my clients want to type 2 two

How to model Product Bundles

The situation: Wholesale sales business process SKU1 and SKU2 can each be sold separately. SKU3 can also be sold separately but is a kit of SKU1 and SKU2. We need to calculate royalties for each unit we sell of SKU1 and SKU2. SKU1 has two royalty

SET1/Q.3 Journalize the following transactions –

Q.3 Journalize the following transactions – Jan 1st – Mr. Shetty started his business with Rs. 80,000/- which he bought as his capital in cash Jan 10th – He purchased goods worth Rs. 30,000/- in cash and Rs. 20000/- on credit. Jan 12th – He paid wages

SET2/Q.3 Journal the following transactions and...

Q.3 Journal the following transactions and post them to the various ledger accounts and prepare the trial balance as on 31st January 2004 January 1 Rao Commenced business with Rs.5000 2 Bought goods for cash Rs.2500 3 Bought office furniture for cash

Walkins For Customer Support Executive In HCL Technologies Ltd

Experience:0 – 1 YearsHCL-Technologies Job Title:Customer Support Executive Location:Chennai Education:Graduate – Any Specialization Name Of company:HCL Technologies Ltd Job Description: Position:Customer Support Executive (Non -Voice BP

how to model an event log

I am trying to model the following event data: Field1 = event date, field2 = event code, field3 = location code, field4 = customer_id, fields5 to 8 are event code specific, ie.

Job Opening For Customer care executive In Wipro BPO Solutions Ltd

Experience:0 – 4 Years Job Title:Customer care executive Location:Pune Education:Graduation – B.A – Any Specialization, B.B.A – Management, B.Com – Commerce, B.Sc – Any Specialization, BCA – Computers, BHM – Hotel Management, PG – MBA, PGDM – Any

Regarding Factless Fact Tables

Some time ago I was asked to build the BI platform for a road safety organization. The warehouse was built of three primary fact tables, each with a collection of associated dimensions. I am now trying to branch out into ETL and Warehouse design, and from

Datasecurity within Business Intelligence

Hi! My name is Daniel and i am graduating on the subject datasecurity within Business Intelligence. My main objective is "how to manage confidential information in is business intelligence (data warehouse and reporting)". I am searching for

PLEASE HELP! I bricked mine..just got yesterday!

I was under the impression that this was basically the same as the Maylong m-150, so I attempted the firmware upgrade for the m150, but it gets to a point about the file system and errors out. Where can I get the factory FW? Thanks in advance!