Skip to Content
Author's profile photo Louis de Gouveia

View Design-Time Data in DS 4.1

Last year I wrote a blog about the new features in data services, this blog can be seen at this link

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.


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.


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.


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

Assigned tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.