Page 1 of 1
uniVerse tables and XMETA tables
Posted: Wed May 14, 2014 8:44 am
by m_mani87
Hi ,
I was digging certain things regading uniVerse tables and XMETA tables.
Im wondering why two types of repositories are present idatastage .
I believe uniVerse tables includes DS_JOBS,DS_AUDITS,DS_OBJECTS etc and XMETA tables include tables like XMETA********.
What is the need for two repositories and what are its specific uses and differences?
Posted: Wed May 14, 2014 8:59 am
by chulett
XMETA supports the new topology and integration into the Infosphere platform, uniVerse is for legacy support... and I do believe all of the legacy structures are duplicated in XMETA.
Posted: Wed May 14, 2014 11:00 am
by m_mani87
You mean the legacy file repository of uniVerse and the Database repository of 8.x versions? . I thought it was for different purposes two repository was present. So we can get all the information in XMETA that we get in uniVerse?
Posted: Fri May 16, 2014 7:04 am
by priyadarshikunal
There is no definitive answer to that. A lot of information is duplicated but not all the information present in XMETA is present in uniVerse or vice-versa.
Posted: Fri May 16, 2014 7:50 am
by rkashyap
To add to Priyadarshikunal's post... DataStage internally uses both the XMETA repository and uniVerse. eg.
1. XMETA Repository - is used to construct the tree displayed by the Designer client and can be queried directly via DStageWrapper -query
2. uniVerse's DS_JOBS file - the indexes on this file are used to construct the tree visible in the Director client.
In case of discrepancy between Repository and uniVerse, the DataStage project gets corrupted.
Posted: Fri May 16, 2014 9:26 am
by eostic
The key question here is not one vs the other, but "what are you trying to accomplish?". Metadata from ionformation Server for DataStage can be garnered in LOTs of ways.....
Ernie
Posted: Tue May 20, 2014 7:30 am
by m_mani87
thanks a lot all..Guess that answered my question