July 29, 2013
July 23, 2013
In our previous post we discussed what is the use of Date Time Dimension in Warehousing environment and shown a demo displaying a Date-Time Dimension using Informatica.
So, in this post we will demonstrate the same implementation using Talend Open Studio.
2)tMap(for data manipulation)
3)tConvertType(to change the data type)
COMPLETE JOB DESCRIPTION:-
In tOracleInput component define two columns as a schema both must be of data type and in sql editor write the query given below.
“select sysdate+level,trunc(sysdate+level,’q’) from dual connect by level < 366”
first column will return you data serially from the current date and second column will give you first date for every quarter.
Most of the implementation is completed using existing components.
To compute monthOfQuarter–
To pull out Weekday in character format use–
To calculate days from first date of quarter–
So, this is how you can implement a basic date-time dimension. Beyond this you can alter this current implementation as per your requirement.
Thanks for giving your precious time….kindly leave a comment in case of any queries ..
July 21, 2013
COMPLETE JOB SNAPSHOT
July 6, 2013
In one of our previous posts we had already covered the concept and implementation of late arriving dimension using informatica.
So, directly we will show you how to achieve this functionality using Talend DI tool.
- Create a first job that will bring the max surrogate key (using sequel query) from the production dimension table and save in one of context variable using tJavaFlex Component. In main code section of tJavaFlex write context.prod_skey=row4.prod_skey;
- Create a second job that runs after successful completion of first job and here bring the tOracleInput_1 component that will bring all the source data that resides into your staging area.
- Pull two more oracle input sources that will act as a lookup one for prod_dim table and other one is for cust_dim table.
- tMap Job Desc as described in the below figure