This content has been marked as final. Show 3 replies
Avoid DAD, it's for application level purpose not for BI (I assume ETL) processes.
That is what even I was thinking but I understand that DAD has Type 4 drivers which are supposed to be fast. I am still wondering if Type 4 is good enough for ETL. I know DAD has an overhead like performing decimal shifts, looking up DD descriptions, security etc. Confused here.
Yes, it's type 4 JDBC but the overhead is critical for ETL process, so don't use for massive data processing.
There are no advantages using DAD in this case (no one I know).