How to join SNP_PACKAGE and SNP_MAPPING

kovar

Hi,

How to join ODI repository tables SNP_PACKAGE and SNP_MAPPING so I can get a list of mappings inside particular package?

- Kovar

Pavan8u

Hi,

Please try this-

select a.pack_name,b.step_name from dev1_odi_repo.snp_package a,dev1_odi_repo.snp_step b

where a.i_package=b.i_package and b.i_mapping is not null;

Regards,

Pavan

Pavan8u

Hi,

Please try this-

select a.pack_name,b.step_name from dev1_odi_repo.snp_package a,dev1_odi_repo.snp_step b

where a.i_package=b.i_package and b.i_mapping is not null;

Regards,

Pavan

Adrian_Popescu-Oracle

Hi,

This note describes ODI repository structure:

1903225.1 Oracle Data Integrator 11g and 12c Repository Description

Adrian