Forum Stats

  • 3,838,255 Users
  • 2,262,346 Discussions
  • 7,900,561 Comments

Discussions

How to join SNP_PACKAGE and SNP_MAPPING

kovar
kovar Member Posts: 46 Red Ribbon
edited Feb 12, 2018 8:30AM in Data Integrator

Hi,

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

- Kovar

Tagged:

Best Answer

  • Pavan8u
    Pavan8u Member Posts: 278 Silver Badge
    edited Jan 30, 2018 4:27AM Answer ✓

    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

    kovar

Answers

This discussion has been closed.