uniVerse tables and XMETA tables

[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?

[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.

[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?

[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.

[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.

[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

[m_mani87]

thanks a lot all..Guess that answered my question