Create Dimension with more than one column from more than one table

[#1]

HI guys,

I am just wondering if it possible to create a dimension from two data sources.

I have two tables Account1 and Account2 and they both a column named 'AccountType'

I need to a create a dimension which should contain values from this column of both tables.

Can you please tell me how can i achieve this?

i do not have option to concatenate both tables.

Saurabh

[swuehl]

Please give an example of these two tables, incl. all fields you need to consider for your new dimension table, could be just some sample lines of data.

Why is concatenating not an option here?

[#3]

Hi Swuehi,

I one fact table

Transactions:

TxnID

TxnLineID

CreditAccountListId

DebitAccountLisID

AccountFulleName

I have one Account Table.

Account:

ListID,

Name,

AccountType

I need to link Transaction with Account to get the AccountType

So here is what i have done

I have created two tables out of one Account table.

CreditAccount:

ListID as CreditAccountListId

Name,

AccountType

DebitAccount:

ListID as DebitAccountLisID

Name,

AccountType

So they are linked.

Now i need to create a dimensions like

AccountType

          AccountName

If i take the AccountType of CreditAccount table then i will leave behind debit accounts and vice versa.

So somehow i need to bring AccountTypes from both columns and linked it with Transactions column.

Saurabh