I am trying to access data from E1 data source for bulk loads into Endeca (For BI purpose). I am assessing the suitability of this driver for a BI/OLAP ETL dataloads. Can someone please tell me if DAD is suitable for such a purpose? What are the disadvantages of using?
From what I remember using E1 DAD limits joins to upto 3 E1 tables, does not support subqueries, does not support left outer joins, does row by row processing rather than bulk loads, etc.
Can someone confirm if my understanding is accurate?
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.