Data Profiling mit SQL Server Integration Services 2008

Download this episode

Description

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.

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image
      mano developer
      Hi!
      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!

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.