Data Profiling mit SQL Server Integration Services 2008

Play Data Profiling mit SQL Server Integration Services 2008
Sign in to queue


Die Datenqualität spielt beim ETL und Data Mining eine entscheidende Rolle. Deshalb ist es zielführend die Qualität der Daten zu prüfen. Idealer Weise sollte eine überprüfung ständig stattfinden, bzw. im ETL vorgenommen werden. SQL Server 2008 unterstützt diesen Vorgang durch einen neunen SSIS Task "Data Profiling". In diesem Screencast erhalten Sie eine Übersicht wie der DataProfiling Task genutzt werden kann und welche Informationen Sie dadurch erhalten.



Right click to download this episode

The Discussion

  • User profile image
    mano developer
    First Happy New Year!
    I would like to ask some questions about Microsoft BI.
    I am from Bulgaria - Sofia university and I chose to write diplom work for my master degree on theme "Microsoft Business Intelligences technologies research".
    My diplom work instructor gave me the following questions as a base points for my diplom work:
    - ROLAP, MOLAP и HOLAP support in Microsoft BI
    - data compression in multidimensional data model
    - maximum possible number of dimensions
    - how Microsoft BI server can process large dimensions containing 700 000-800 000 elements in a dimension
    - are there specialized solutions to problems as segmentation of calculated changes of dimension hierarchies for a given period in the time
    - what methods are there for working with non-additive facts(for example  non-additive  facts caused by "many to many" relations)
    My main problems are with the last 2 questions - I have searched so hard, but I have not found no info about this.
    I would be very glad if you can help me or tell me where to find info about this.
    Every internet address or you can give me will be very helpful for me.
    Have a nice day!

Add Your 2 Cents