InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Can A Qvd Be Accessed From A As400 Db2 Database To Get Some Data? |
|
Answer» Nothing but Qlikview can read from QVDs, so no, DB2 cannot read directly from a QVD. In the same script that creates the QVD with the store statement: STORE mytable INTO mytable.qvd (qvd); You can also create a CSV copy for other consumers: STORE mytable INTO mytable.csv (txt);The csv file can be read by any number of programs, including an ODBC text driver or a bulk database loader. You can use QV to do the ETL and then push csv files back into a DATA Warehouse, using SOMETHING LIKE SQL Server DTS or other data pump. Nothing but Qlikview can read from QVDs, so no, DB2 cannot read directly from a QVD. In the same script that creates the QVD with the store statement: STORE mytable INTO mytable.qvd (qvd); You can also create a CSV copy for other consumers: The csv file can be read by any number of programs, including an ODBC text driver or a bulk database loader. You can use QV to do the ETL and then push csv files back into a Data Warehouse, using something like SQL Server DTS or other data pump. |
|