Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

ETL Timestamp of Data Warehouse

 
Hi Folks,

Is there a data row in the Data Warehouse schema (https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20) showing the timestamp of the most recent ETL? especially the end time of the ETL as shown in  https://jazz.net/mhonarc/lists/jazz-dev/msg04233.html

Thanks very much!

Qi

0 votes



2 answers

Permanent link
Check the config.etl_info table for the information.

0 votes

Comments

Sandy, thanks very much for your answer, can you specify which data warehouse snapshot might contain the config.etl_info table? 


Thanks!

Qi 

The config.etl_info  table unfortunately is not exposed as a snapshot, you need to run an SQL command to get the information.


Permanent link
You can iterate over any "history" data set and remember latest timestamp. Also you can watch how it's implemented in OOTB reports using warehouse.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,126
× 324

Question asked: Nov 06 '12, 1:50 p.m.

Question was seen: 7,976 times

Last updated: Mar 20 '13, 5:54 p.m.

Confirmation Cancel Confirm