It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×6,076
×324
×103

question asked: Nov 06 '12, 1:50 p.m.
question was seen: 7,312 times
last updated: Mar 20 '13, 5:54 p.m.

Related questions

FAQ - How this Forum works

ETL Timestamp of Data Warehouse

0
Qi Li (13●5●17●18) | asked Nov 06 '12, 1:50 p.m.
JAZZ DEVELOPER
 
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

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Sandy Grewal (1.6k●12●23) | answered Nov 06 '12, 1:55 p.m.
JAZZ DEVELOPER
Check the config.etl_info table for the information.
Comments
Qi Li commented Nov 06 '12, 2:10 p.m.
JAZZ DEVELOPER

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


Thanks!

Qi 

Sandy Grewal commented Mar 20 '13, 5:54 p.m.
JAZZ DEVELOPER

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

0
permanent link
Vladimir Amelin (704●7●22●26) | answered Nov 07 '12, 1:19 a.m.
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.

Your answer

Register or 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.