3 Replies Latest reply on Dec 17, 2018 8:08 AM by Robert Whelan

    Profile by Dimension

    Sina D New Member

      Hi

       

      I am brand new to Informatica. I have been trying to profile some large tables in my Oracle database. I have been using Informatica Analyst version 10.2 and PowerCenter Developer 10.2.  It's very good when it comes to profiling the columns on object. However, I need to profile the data in the table by specific dimensions. So for example I need to use my Country_code as the dimension so the results of the profile are shown for each country.

       

      There is nearly 100 countries in the database so I don't fancy doing a profile for each country manually. Is there way to achieve this without having to repeating the task for each country?

       

      Hope this make sense.

       

      Thanks in advance!