Answer Detail: RE: In what scenario ETL coding is preferred than Data...

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Print |

Question: In what scenario ETL coding is preferred than Database level SQL,PL/SQL coding?

August 08, 2007 01:40:50	#1
harikrishna	Member Since: Visitor Total Comments: N/A
RE: In what scenario ETL coding is preferred than Data...
Data scrubbing process is difficult. That is, file contains date column like 20070823 but data warehouse requires date as 08/23/2007 in that case it is difficult.