- Forum
- Databases
- Data Warehousing - A senario to create a complex mapping
-
A senario to create a complex mapping
Could you please give me a senario to create a complex mapping, like what were the transformation in the mapping and what could be the business logic to implement for being a complex mapping in a financial company
Question asked by visitor Zaman
-
Junior Member
Re: A senario to create a complex mapping
complex scenorio u can say is slowly changing dimensions, almost all mappings will be present in SCDsi.e.lookups,storedprocedures etc(check in the wizard optin n the tolbar).in scds TPYE1,TYPE2,TYPE3 are there for type1:current records we can store
type2:current+historical
type3: same as type2.
normally we use type2.in this the main logic is updating.inserting,deletion of the records.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules