View Complete Post
Is there any direct equivalent concept of Oracles ,ROWID in SQL Server. As you might be knowing that ROWID is the unique hex number given to each record of a table in Oracle. The column is not added explicitly , automatically it will come ..
and we can do certain queries using ROWID ..
Please let me know ,is there any equal concept in SQL Server. I verifyied , NEWID(),GUID() ... etc concepts ..
NOTE: I don't want to add the column to the table EXPLICITLY ...
Please let us know if there is any ALTERNATE way ...
Thans in advance
Scenario: Bank Accounts and Customers. One Account can have many customers and many customers can have one joint Account. so its Many to Many relationship.
Special Scenaio: Bank provide us daily snapshot of all thier dimensions and facts, every night thier ETL run, and newsnapshot is available, previous is gone.
I am using SCD Transformation to update the dimensions, Type 1 for all the columns.
Tables1: DimAccounts (AccountsID(PK))
Table3:DimBridge (AccountID (FK), CustomerID(FK), RelationShip (varchar10))
Question1: Are we supposed to treat bridge tables as Dimensions or Facts?
Question2:If it is to be treated as Dimension, How would I apply SCD Wizard to it, Since there are two business keys involved?
Question3: Do i need surrogate key in Bridge Table, like i have in other dimensions?