Tons of useful information in this thread...thank you all...
Typically the ETL maps/jobs needs a fixed source table/file structure so that it can read from that and move data to the target dimensional model. So, the customer has to download data from their environment to a format recommended by saas vendor, which would then be consumed by the ETL tool and transformed to the star model.
What if the customer doesn't have the bandwidth/resources to create extraction routines that would create data in the recommended format?
Wouldnt' that be a huge challenge for the saas vendor because they have to now convert and load all these disparate formats of data into one stage area model and then eventually load the star model.
Anyone resolved this issue before?
Ramesh.
Posts
No comments:
Post a Comment