Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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