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




            (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