January 14, 2014 at 12:14 pm
AFAIK, ETL integrates data from a fixed number of sources/tables. Is it possible that ETL can integrate data from an unknown number of tables which might be added in the future, given that these tables might be of different types (customer, shipping, employee, accounting etc.) ? Are there any solutions in SSIS which handle these kinds of scenarios ?
EDIT -
Let A,B,C be tables. We can have the following ETL scenarios - A + B + C = 1 row or A + B + C = 3 rows
I have the first one. Later, we can add tables D,E,F,G...etc all of which might be different from each other in terms of the data they contain.
January 14, 2014 at 1:37 pm
I'd say - not nearly enough info to answer.
What would you do with the data from those unknown sources? Is the handling generic in some way?
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply