Answer Detail: RE: how can u implement slowly changed dimensions in d...

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?

December 12, 2005 15:06:07	#3
rama	Member Since: Visitor Total Comments: N/A
RE: how can u implement slowly changed dimensions in d...
SCDs are three typesType 1- Modify the changeType 2- Version the modified changeType 3- Historical versioning of modified change by adding a new column to update the changed data