Conditional statement in SSIS: same as ternary operator in C
** <condition>? <true>:<false>
Eg: Gender=="M" ? "Male": "Female"
Multicast Transformation: This t/r creates multiple copies of i/p data. it is useful because every time we need not to go to source.
** This will improve task performance.
Aggregate Transformation: It is used to convert the detailed values into aggregated data by using Aggregate functions like sum,avg,max,min,count etc.
** It is Asynchronous transformation.
Example: to the i/p data from source group by deptno and perform aggregate funcs.
Conversion in SSIS;
* Conversion is very important because data from flat file, excel comes to transformations in the form of string(varchar) , so we cannot perform required operations so it require to convert data.
1) Directly at source level:
** Select flat file source, right click--> show advanced editor.
** Select i/p & o/p properties tab, expand flat file source o/p and expand o/p columns.
** Now select o/p column and in the properties window set the data type to required data type.
2) Using type casting functions in the t/r 's like conditional split and derived column:
Eg: (DT_I4)[Sal]*0.1
** <condition>? <true>:<false>
Eg: Gender=="M" ? "Male": "Female"
Multicast Transformation: This t/r creates multiple copies of i/p data. it is useful because every time we need not to go to source.
** This will improve task performance.
Aggregate Transformation: It is used to convert the detailed values into aggregated data by using Aggregate functions like sum,avg,max,min,count etc.
** It is Asynchronous transformation.
Example: to the i/p data from source group by deptno and perform aggregate funcs.
Conversion in SSIS;
* Conversion is very important because data from flat file, excel comes to transformations in the form of string(varchar) , so we cannot perform required operations so it require to convert data.
1) Directly at source level:
** Select flat file source, right click--> show advanced editor.
** Select i/p & o/p properties tab, expand flat file source o/p and expand o/p columns.
** Now select o/p column and in the properties window set the data type to required data type.
2) Using type casting functions in the t/r 's like conditional split and derived column:
Eg: (DT_I4)[Sal]*0.1
Comments
Post a Comment