Skip to Content

Last year I wrote a blog about the new features in data services, this blog can be seen at this link http://t.co/iYqXUnbL

Today I’m going to focus specifically on one of the new features in Data Services 4.1 called “View Design-Time Data”.

Anyone that has worked with Data Services will know that you can only see the results of your transformations by running or debugging the dataflow. So while designing it is not possible to see what the result is.

So below is an example of a simple dataflow with a query transform.

DataServices.jpg

Now when you double click on the query transform the below is viewed. As seen below the transform has a simple calculation to calculate profit. But we also can see the “Schema In” and what columns we want to be used in “Schema Out”.

DS Transform 4.1.jpg

Now we have the option to turn on View Design-Time Data as shown below.

ViewDesignTimeButton.jpg

This then provides two new windows showing the data coming into the schema and the data going out of the schema based on our mappings. But more importantly we can see the results from the calculation done in our profit column.

DSTransformViewDesignTimeResult.jpg

The above is a simple example, but anyone that has done some complex Data Services data flows will know how handy this new feature will be.

So now we can view the results of our transforms while designing.

Follow me on twitter @louisdegouveia for more updates

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply