3 Replies Latest reply on Sep 23, 2016 4:41 AM by swethanaveen

    Informatica BDM vs Informatica Powercenter Express Tool

    New Member

      Hi, I want to learn Informatica BDM. When I have downloaded Infa BDM for Hortonworks, I see that Informatica Developer tool being used for interacting with Hadoop/Hive.

       

      So does that mean if I just learn how to use Informatica PC Express tool (i.e., Informatica Developer Tool) will that fits the need of using/learning Infa BDM except the hadoop/hive connectivity.

       

      Any help appreciated. Thanks!

        • 1. Re: Informatica BDM vs Informatica Powercenter Express Tool
          Xitiz Pugalia Guru

          The GUI & Tools are same i.e. Informatica Developer.

          Except a few features here & there, you'll be on your way to work on Informatica BDE if you learn Powercenter Express.

           

          The core engine remains the same...

           

          Hope it helps.

          • 3. Re: Informatica BDM vs Informatica Powercenter Express Tool
            New Member

            select A.tablespace_name,

             

            case when B.Total/1024/1024/1024 < 1 then round(B.Total/1024/1024,2)||' MB' else round(B.Total/1024/1024/1024,2) ||' GB' end Total,

             

            case when A.total_free/1024/1024/1024 < 1 then round(a.total_free/1024/1024)||' MB' else round(a.total_free/1024/1024/1024,2)||' GB' end Free,

             

            case when (B.total-a.total_free)/1024/1024/1024 < 1 then round((b.total-a.total_free)/1024/1024)||' MB' else round((b.total-a.total_free)/1024/1024/1024,2)||' GB' end Used,

             

            round((b.total-a.total_free)/b.total*100,2) "Usage(%)",

             

            round((a.total_free/b.total)*100,2) "Free(%)",status

             

            from

             

            (Select Tablespace_Name, Sum(Bytes) Total_Free From Dba_Free_Space Group By Tablespace_Name) A,

             

            (Select Tablespace_Name,status, Sum(Bytes) Total From Dba_Data_Files Group By Tablespace_Name,status) B

             

            where a.tablespace_name = b.tablespace_name and a.tablespace_name not like 'UNDO%' and a.tablespace_name not in ('SYSTEM','SYSAUX','USERS')

             

            order by 5 desc