Skip to main content

14th Day

Merge Join T/r:

* This t/r is used to join 2 sources with dissimilar structures based on a joining condition.

*Difference between merge and merge join is

1) Here M-J joins sources with dissimilar structures.

2) Both t/r's should have at least one  common column and that in sorted order and of same datatype

3)Here we can implement inner join , left join , right join.

Ex: Take a flat file source and table as emp , oledb source table as dept , convert the dno column into same datatype and give the o/p's of sources  to sort t/r and from sort to merge join, to at last oledb destination.

Audit T/r:

* It adds some new column's like package name, task name, machine name, user name and execution time as o/p to the available i/p columns.

Ex: Try with a flat file source, link it to audit t/r.

Row Sampling and Percentage Sampling T/r:

* This t/r is used to generate specified number/percentage of random records from the source.

* It takes single i/p and gives 2 o/p's Sample records and Unsample records.

* To generate same random records for the next run use the seed value.

Ex: try with a oledb source. also try copy column t/r.

Comments

Post a Comment

Popular posts from this blog

Lesson 57: Auto refresh the report in SSRS

                     How to Auto refresh the report in SSRS. Firstly create a datasource,dataset and select the required fields into the table/matrix. If you want to refresh the report frequently for every second you can change the Auto refresh as 1 in the properties of the report. If you want to change the color of a field after given period of time to change the expression of the color in properties as a follows and set the Auto refresh time to the required period of time in the report properties.
Post a Comment
Read more

12th Day

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, ...
Post a Comment
Read more

Lesson 67: Join two datasets in SSRS by using Lookup function

How to join two datasets in SSRS by using Lookup function First create two datasets each one with a different datasource. Next insert a table in the report body and insert the required columns from the dataset1. Next in order to insert the columns from 2nd dataset, you need to write a look up function where you need to give the matching columns from both the datasets and the required column from dataset and scope as 2 datset Here since we are inserting the columns of dataset1 first, we are writing exp with scope as dataset 2.
Post a Comment
Read more