| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: how can u implement slowly changed dimensions in datastage? explain?
2) can u join flat file and database in datastage?how?
|
| March 03, 2006 21:30:53 |
#5 |
| RamaPrasad Batchu |
Member Since: Visitor Total Comments: N/A |
RE: how can u implement slowly changed dimensions in d...
|
| We can handle SCD in the following waysType I: Just overwrite; Type II: We need versioning and dates; Type III: Add old and new copies of certain important fields. Hybrid Dimensions: Combination of Type II and Type III |
| |
Back To Question | |
