Xmeta versus Universe

Poovalingam · Post by **Poovalingam** » Thu Jan 22, 2015 2:47 am

Hi,
I found one sql to query DS_JOBOBJECTS in Universe to get the list of jobs using the column name with pattern XXX. I think after 8 version we do have Xmeta database contains all meta information.
Does it mean datastage maintains 2 meta data repository, one in Universe and another in Xmeta after 8X? Shall we completely trust Universe meta data information? Please advise your comments.

Thanks & Regards,
Poovalingam.

chulett · Post by **chulett** » Thu Jan 22, 2015 9:13 am

Poovalingam wrote:Does it mean datastage maintains 2 meta data repository, one in Universe and another in Xmeta after 8X?

Yes.

Poovalingam also wrote:Shall we completely trust Universe meta data information?

Yes.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 22, 2015 3:37 pm

... except DS_AUDIT, which now seems to be less complete than before.

chulett · Post by **chulett** » Thu Jan 22, 2015 3:58 pm

Duly noted. Is there an equivalent in XMETA?

ray.wurlod · Post by **ray.wurlod** » Thu Jan 22, 2015 10:51 pm

Yes and no. Auditing of security events is handled in audit log files (outside of XMETA). Date/time created/modified are recorded in XMETA, and reported via tools such as Information Governance Catalog or Metadata Workbench.

Poovalingam · Post by **Poovalingam** » Fri Jan 23, 2015 4:43 am

Thank you so much Ray and Craig.

Regards,
Poovalingam.

DSXchange

Xmeta versus Universe

Xmeta versus Universe

Re: Xmeta versus Universe