May 18, 2013
Today we will discuss how to add custom header and footer using Talend Open Studio.
In your third job while fetching data use limit = 1 for records and only select one column in your schema definition and further in tJavaFlex component use the following code to print the number of rows at the header.
|for last two output_files|
*file names in all the three jobs must be same with different select options.
Thank you for reading…
May 16, 2013
Today we will discuss how to merge multiple files in Talend Open Studio with sorting operation on all.
Scenario: Merging multiple input sources into a single target along with the file names with a additional column and sorting operations on all files with in the flow
The snapshot below shows the overall mapping.
Later tMap is used to assign one extra column which holds the name of the file and again name of the file is to be retrieve using global variable in our case it is
After completion of first job we fire a onSubJobOk trigger to do our rest work.
that’s all, now you can create a job and simply run it—>>>
Thanks for reading……
May 9, 2013
All of the dimension tables are SCD-type implemented other than TIME DIMENSION.