派生列和数据转换之间有什么区别？ [英] What is the difference between derived column and data conversion?

问题描述

我们有两个转换来转换数据类型所以请告诉我方案，以便我能清楚地理解它究竟是什么？



我尝试过：



我们有两个转换来转换数据类型，所以请告诉我情景，以便我能清楚地理解它究竟是什么？

'



任何答案都将不胜感激...

解决方案

数据转换的目的是只进行数据转换。



虽然派生列任务用于大多数转换。为实现这一目标，数据转换也作为其中的一部分。如果您只是打算进行数据转换而不打算进行其他转换，那么包的简单性和可读性。



数据转换为最终用户提供了一个简单的用户界面填写更改传入列的数据类型的要求。



派生列也可以帮助我们实现数据转换但是我们必须明确地编写代码来输入类型这一点。

We have two transformation to convert datatype so please tell me with scenario so i can understand clearly what it is exactly?

What I have tried:

We have two transformation to convert datatype so please tell me with scenario so i can understand clearly what it is exactly?
'

any answer would be greatly appreciated...

解决方案

The purpose of Data conversion is to do just data conversion.

While Derived column task is used for most of the transformations. To achieve this, data conversion is also put in as a part of it. If you are just intending to do data conversion and no other transform, for simplicity and readability of the package.

Data conversion gives a simple UI to the end user for full filling the requirement of changing the data type of incoming columns.

Derived columns also can help us to achieve data conversion but there we have to explicitly write a code to type cast that.

这篇关于派生列和数据转换之间有什么区别？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！