GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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?




February 02, 2006 03:38:27 #4
 Sharanu Patil   Member Since: Visitor    Total Comments: N/A 

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

yeah u can implement SCD's in datastage

SCD type1

just use 'insert rows else update rows'

          or

   ' update rows  else  insert rows'  in update action of target

SCD type2

u have use one hash file to look -up the target ,take 3 instance of target ,give diff condns depending on the process,give diff update actions in target ,use system variables like sysdate ,null

     

 

Back To Question