2 Replies Latest reply on May 22, 2012 12:35 AM by user144725

    To find the flat file used in Loopkup & Sources

    New Member

      Hi

          I have several flat flies used in Lookup.

          How do I find the Flat file names that are used for the Lookup.

          I am not looking for Lookup, if it is using any tables.

          I want to find by quering from Repository tables.

       

          Similarly I am looking for Mapping that are using Flat files.

       

       

      Thanks and Regards

      Dmishra

        • 1. To find the flat file used in Loopkup & Sources
          user155158 Active Member

          Hi,

          From following tables you will get to know details of files and lookup used in mapping

           

          REP_SRC_FILES

          REP_ALL_TRANSFORMS

           

          you can join above repository tables to get required result .

           

          Regards,

          Ajit

          • 2. To find the flat file used in Loopkup & Sources
            Guru

            Query to get all flat file lookup transformation details

             

            select d.subj_name folder_name,c.Mapping_name,a.Instance_name transformation_name

            from REP_WIDGET_INST a, REP_WIDGET_ATTR b, opb_mapping c,opb_subject d where

            a.mapping_id=c.mapping_id

            and a.widget_id=b.widget_id

            and a.subject_id= c.subject_id

            and a.subject_id= d.subj_id

            AND a.widget_type=11

            AND b.widget_type=11 --- Lookup Transformation

            and b.ATTR_NAME='Source Type'

            and b.ATTR_TYPE='6' ---- Flat file