Hi, how does one build an SQL query that defines the initial data transfer to a data warehouse??
Thanks... I have not failed; I have merely found 100,000 different ways of not succeding...
Depends on what you mean with 'initial'. Do you mean the very first time that you populated your datawarehouse with ANY data at all? That does not sound anything for SQL to handle. With DB2 you have the db2diag.log file that records this sort of things for a given instance.
Please state with which type of RDBMS you are working and define more closely what you want. I have a feeling you may want something else alltogether........ T. Blom
Information analyst
tbl@shimano-eu.com
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.