Techie's House

Privacy Policy For Racoon Bubble Shooter

2018-10-02T00:08:00.001-07:00

Privacy Policy

Praveen Kumar Singh built the Raccoon Bubble Shooter app as a Free app. This SERVICE is provided by Praveen Kumar Singh at no cost and is intended for use as is.
This page is used to inform visitors regarding my policies with the collection, use, and disclosure of Personal Information if anyone decided to use my Service.
If you choose to use my Service, then you agree to the collection and use of information in relation to this policy. The Personal Information that I collect is used for providing and improving the Service. I will not use or share your information with anyone except as described in this Privacy Policy.
The terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, which is accessible at Raccoon Bubble Shooter unless otherwise defined in this Privacy Policy.
Information Collection and Use
For a better experience, while using our Service, I may require you to provide us with certain personally identifiable information. The information that I request will be retained on your device and is not collected by me in any way.
The app does use third party services that may collect information used to identify you.

Link to privacy policy of third party service providers used by the app

Google Play Services
AdMob

Log Data
I want to inform you that whenever you use my Service, in a case of an error in the app I collect data and information (through third party products) on your phone called Log Data. This Log Data may include information such as your device Internet Protocol (“IP”) address, device name, operating system version, the configuration of the app when utilizing my Service, the time and date of your use of the Service, and other statistics.
Cookies
Cookies are files with a small amount of data that are commonly used as anonymous unique identifiers. These are sent to your browser from the websites that you visit and are stored on your device's internal memory.
This Service does not use these “cookies” explicitly. However, the app may use third party code and libraries that use “cookies” to collect information and improve their services. You have the option to either accept or refuse these cookies and know when a cookie is being sent to your device. If you choose to refuse our cookies, you may not be able to use some portions of this Service.
Service Providers
I may employ third-party companies and individuals due to the following reasons:

To facilitate our Service;
To provide the Service on our behalf;
To perform Service-related services; or
To assist us in analyzing how our Service is used.

I want to inform users of this Service that these third parties have access to your Personal Information. The reason is to perform the tasks assigned to them on our behalf. However, they are obligated not to disclose or use the information for any other purpose.
Security
I value your trust in providing us your Personal Information, thus we are striving to use commercially acceptable means of protecting it. But remember that no method of transmission over the internet, or method of electronic storage is 100% secure and reliable, and I cannot guarantee its absolute security.
Links to Other Sites
This Service may contain links to other sites. If you click on a third-party link, you will be directed to that site. Note that these external sites are not operated by me. Therefore, I strongly advise you to review the Privacy Policy of these websites. I have no control over and assume no responsibility for the content, privacy policies, or practices of any third-party sites or services.
Children’s Privacy
These Services do not address anyone under the age of 13. I do not knowingly collect personally identifiable information from children under 13. In the case I discover that a child under 13 has provided me with personal information, I immediately delete this from our servers. If you are a parent or guardian and you are aware that your child has provided us with personal information, please contact me so that I will be able to do necessary actions.
Changes to This Privacy Policy
I may update our Privacy Policy from time to time. Thus, you are advised to review this page periodically for any changes. I will notify you of any changes by posting the new Privacy Policy on this page. These changes are effective immediately after they are posted on this page.
Contact Us
If you have any questions or suggestions about my Privacy Policy, do not hesitate to contact me.
This privacy policy page was created at privacypolicytemplate.net and modified/generated by App Privacy Policy Generator
-->

Talend ETL Tutorial : How To Do Data Validation Using tSchemaComplianceCheck Component

2017-03-19T04:57:00.003-07:00

Thanks for your visit !!

The article has been moved here: Talend ETL Tutorial : Data Validation

Talend ETL Tutorial : How To Check For Reject Row Option In Talend Components

2017-03-12T10:36:00.000-07:00

Thanks for your visit !!

The article has been moved to new website : Talend ETL Tutorial : How To Check For Reject Row Option

Talend ETL Tutorial : How To Run Talend Jobs Externally (Without Talend Open Studio)

2017-03-04T21:33:00.001-08:00

Thanks for your visit !!

This article has been moved to new website : Talend ETL Tutorial : How To Run Talend Jobs Externally

Talend ETL Tutorial : How To Run Jobs In Sequential And Parallel Mode In Talend Studio

2017-02-26T06:26:00.000-08:00

Thanks for your visit !!

This article has been moved to new website :

Talend ETL Tutorial : How To Run Jobs In Sequential and Parallel Mode

Talend ETL Tutorial : How To Implement Right Outer Join Functionality In Talend

2017-02-20T21:10:00.001-08:00

Yesterday, I was going through the unanswered posts of Talendforge forum and one question caught my eye. It was titled as Problem with Joins. First, I thought it would be related to some settings problem but it was not. It was related to one scenario that required the implementation of Right Outer Join. In Talend, we can join using two components: tJoin and tMap. The problem is: tJoin only supports Inner Join whereas tMap supports only Inner Join and Left Outer Join. So, we have no way of direct usage of Right Outer Join. You have to find another way of implementing it. This is my workaround for the mentioned problem, you can think of another approach also.

Talendforgre forum question: Problem with the joins

Requirement

Click To Enlarge

Final Job Design:

Steps For Processing:

First, I have created 3 delimited files with a comma (,) as a delimiter and placed all these records as per the requirement in the files. Now, to read all these input files, I am using tFileInputDelimited component.My thought is to create two data sets and then merge them to Right Outer Join way. To achieve this, I am joining first two input files Literacy_rate.csv and Graduation_rate.csv. As I don't have to skip any records from here, I am using tJoin component for INNER JOIN.

We want all columns from both input files. To get this, go to Edit Schema and add columns as per your need.You can just simply use -> (arrow symbol) to move columns from one panel to another.We will get Year, Grade_Rate and Literacy_Rate columns from the input files but we also have to add one extra column specifically so that it can work with the tUnite component. tUnite expects same schema structure from its sources. So, this will give me the first dataset. And, it will have all records from both input files.

In the second dataset, we will try to capture the records from Grade_count.csv. In the output, we should have matched records for the year 2011 and 2012 as these years are present in the above-mentioned input files. In the output, we should have the values for the respective columns.Also, we should have an entry for Year 2013. Grade_count.csv data will be our Main records and rest two files records will be lookup and the join mode will be Left Outer Join.

The next step is to merge this dataset with the other dataset. To merge it, I am going to use tUnite component. Also, in this case, and as per our requirement, set the order as mentioned in the below screenshot.

The next step is to remove the duplicate records. We would be getting two sets of records for the year 2011 and 2012 form the first and second dataset and we just have to keep the values from the second dataset as it will have correct values for all the columns. I have defined the key as Year to filter out records. tUnique will take first records and drop the second occurrence. To make sure the tUnique picks the dataset coming from tMap. We have defined the merge order as mentioned in the above screenshot.

I am using tSort row next to just align the data in the ascending order of the years.

Once you execute this job, you will get an output like this:

Talend ETL Tutorial : How To Extract Records From Multiple Sheets Of Different Schemas In Excel

2017-02-11T00:08:00.003-08:00

In the last post, we covered how to write records into multiple sheets of an excel from a single delimited input file. This post is about reading the records from multiple sheets present in an excel file. You can't directly read and write records from different schemas excel sheets so we need to involve few more Talend components while doing the transformation. We have already seen how to use tBufferInput and tBufferOutput component for the purpose of temporary storing records while writing into Excel. For the reading purpose, we will use tMap component to define different schemas as per our output requirement.

Requirement

The requirement is to read multiple sheets present in an excel file. Also, the schema of each sheet is different. Extract all records available in the sheets and place it into two different CSV files based on the sheet name.

Input

Output

Final Job Diagram

Steps For Processing

The first step is to read the excel file. The first step is to create a Metadata for this excel file. We will define the schema as the Repository level. Also, our excel has sheets with different schemas so we can't read both sheets with the predefined schemas specific to one sheet. The trick is to first, select All Sheets while defining the schema and second, take the schema of the sheet which has the most number of columns. Please check below screenshots:

In next screen, you will get the preview of the records. You may not get the desired sheet record as per your requirement. You need not bother about the records. Just make sure you get the number the exact number of columns as per your need. In my input, the max number of columns(4) are on the Details sheet. Even though I am getting the Name sheet records are here but I am ok with as the number of columns is 4 here.

In the next screen, you will get the preview of the Metadata. You can rename the column's name based on your whim. But in this scenario, just keep the column names as general as possible. As these 4 columns will only store the records of both sheets. Later, we will define the exact schema as per our need.

The next step is to split records as per our need. In our requirement, we have to split records based on our sheets. To split the records, we are going to use tMap component. To read the CURRENT SHEET , we are going to use the global variable : ((String)globalMap.get("tFileInputExcel_1_CURRENT_SHEET"))

I am just storing this Expression under Variable var1. If you want, you can use it directly in the ou1 and out2 expression editor. Using a variable here makes code clean and concise.

So. once done with the mapping, you can rename the columns based on your output requirement. As you can see it here, the input columns will store both sheets records. I am detecting the current sheet to be read and then mapping the input columns to output based on the current sheet's schema. This is the only trick that you have to apply while using multiple sheets of an excel file.

The next step is to just map this output to the two different CSV file. The configuration would be like this:

Talend ETL Tutorial : How To Create Multiple Sheets In An Excel File

2017-02-08T06:52:00.000-08:00

In my previous posts, I have covered how to read an excel and put the data into it. But, it was only related to one sheet of the excel file. What if we have to generate the multiple sheets for the records coming from an input file? It's possible and there is a way to do it.You can create N number of sheets based on your requirement. In this post, I am going to create two sheets in an excel file. Let's check how to do it.

Requirement

The requirement is to process the fixed length file and generates output in the Excel sheet. The output will be displayed in two different sheets of the same Excel file.

Input

Output

The Final Job Diagram

Steps For The Processing

The first step is to read our input file.The input file is the fixed length file.To read this file, define the metadata using File Positional option.To define the Metadata, go to the File Positional option and define the positions as per your input file. I have defined the Metadata as per my input file:

Once you define the Metadata, you can read the input file using tFilePositional input file. The configuration would be as mentioned in the below screenshot:

As we have to split the single input file into multiple sheets, we are going to use tMap components to split the contents. The configuration of tMap component would be as mentioned in the below screenshot:

Now, next thing is to put these records into the Excel file. For this, we are going to use tFileOutputExcel. The configuration would be like this:

We can't define more than one sheet name here. But, there is a workaround for this. We are going to use tBufferOutput to store the records for the second sheet in memory and later will use the tBufferInput component to retrieve those values. tBuffer* components provide you the temporary location to store and retrieve records.

You can automatically populate the schema for tBufferOutput by pressing Sync columns. But, this can't be done for tBufferInput, you have to manually define the schema for this component.As we are going to retrieve what we store in memory using tBufferOutput, we have to use the same schema as in tBufferOutput. The schema would be same as mentioned in the below screenshot:

The last step is to link the tBufferOutput to the Excel using tFileOutputExcel component. We have to link to the same Excel as we want to write into the same Excel but in a different sheet. Give the new name for the sheet and don't forget to tick the Append Existing File and Sheet.

Talend ETL Tutorial : How To Filter Records Using tFilterRow In Talend Open Studio

2017-01-14T06:08:00.001-08:00

In my last Talend tutorial, I have covered how to use tMap component to reject rows from Input file. There is an alternative to it, instead of using tMap component, we can also use tFilterRow component to filter the records. I am going to use same scenario as used in the previous post and will try to achieve same output as we got in the last post.

Requirement

In this demo, we are going to process an input file. This input file has only one column: NAME.We are going to pick records which start with only A or B and will reject rest of the records. The input file is as mentioned below:

The Final Job Diagram :

Steps For The Processing :

The first step is to read the input file. As used in the previous posts also, I am going to use tFileInputDelimited component to read the file. The configuration of this components is as below:

The next step is to process records based on our requirement. We have to analyze the first character of the input records and have to check whether it is equal to A or B. For the processing, we are going to use tFilterRow component. The whole configuration will look like this:

The code :

input_row.Name.substring(0,1).equals("A")||input_row.Name.substring(0,1).equals("B")

A template is already provided by Talend to use the filter condition in advanced mode. This will give you the hint how to call columns. This window gives us a lot of dynamism as we can write our own custom condition in Java and we don't have to rely only on the existing functions which are very few and basic for the filter criteria.

Please check this link to learn how to use Substring in Java.

tFilterRow Demystified..

tFilterRow provides us two mode of filtering : Simple and Advanced. The Simple Mode filtering requires you to select values from the given options. To add your columns and filter criteria, just click on the (+) button. But, you won't get so much options to choose from, the given options under Function and Operator are very basic. The next option is the Advanced Mode. This option add a lot of dynamism in the tFilterRow and makes it very powerful. Here, you can use your basic Java skills and add the criteria based on your will. If you want to use both mode, then select And condition from the dropdown under Logical Operator Used To Combine Conditions.

You can get more details from here : tFilterRow In Detail

Once you are done with the tFilterRow configuration, just link it to the desired output component. I am using tLogRow component here. Similarly, you can use tFileOutputDelimited to put the records in the text file.

Also, you don't have to define anything specifically for the Reject Rows and to link it to the output component. First, click on the tFilterRow component, Go to Row-> Filter and connect first tLogRow component. Next, repeat the same process but this time Talend will only give you Reject option, use this to link other tLogRow component.

Click on the Reject Rows to get more details about it. The Reject row comes with the default Error message column.

The Final Job Execution and Output :

You will get an output like this once you run the Job :

Talend ETL Tutorial : How To Reject Rows From Input File Using Talend Open Studio

2017-01-11T21:26:00.000-08:00

We usually get the requirement where we have to pick some rows and have to drop others based on some conditions. This requires the processing of an input file. If you have worked on some ETL tools before like Datastage, then Transformer is your component for the processing. Same way, Talend provides tMap component for processing. In this demo, we are going to filter rows using tMap component.

Let's check how to get it done...

Requirement

In this demo, we are going to process an input file. This input file has only one column: CITY.

We are going to pick records which start with only A or B and will reject rest of the records. The input file is as mentioned below:

The Final Job Diagram:

Steps For The Processing

The first step is to read the input file. As used in the previous posts also, I am going to use tFileInputDelimited component to read the file. The configuration of this components is as below:

The next step is to process records based on our requirement. We have to analyze the first character of the input records and have to check whether it is equal to A or B. For the processing, we are going to use tMap component. The whole configuration will look like this:

(Click To Enlarge)

At the left side of the screen, we will get the input columns. As soon as we connect the input to the tMap, all the columns will get automatically populated.

At the right side of the screen, you can see two output window: out1 and out2. This is required as we are going to filter the records based on the condition. The out1 window is for the valid records ( The records that will match our criteria). The out2 window is for the rejected records.

To put the conditional statement, first of all, open the expression editor. Once you are inside the expression editor, you can use the different functions as provided by Talend. Here, I am using LEFT function under StringHandling categories.

To reject records, we don't have to put any condition specifically. Talend provides a feature to reject records and we are just using that. Just open the tMap settings and select the value as True for Catch Output Reject.

Finally, we just have to place records coming out from Ou1 and Out2 to an output file. For this, we are going to use tFileOutputDelimited component. The VALID.txt file will store the records which are matching our criteria and the rest will go to INVALID.txt.

The Final Job Execution:

It's time to execute our designed job. The final result would be like this:

Talend ETL Tutorial : How To Iterate Data Present In An Input File

2016-12-31T22:31:00.000-08:00

In one of my previous posts, I have covered how to iterate through the files present in a directory or subdirectory and display the data present in it. But, what if the requirement is to iterate through the data present in an input file. This requires few more Talend components to be included in the Job design.

Requirement

The requirement is to read the input file and create a separate file based on the CITY column present in the file.This requirement is definitely required to read and iterate data from the input file.

Steps To Iterate Data Present In Input File

The first step is to read the input file. As used in the previous posts also, I am going to use tFileInputDelimited component to read the file. The configuration of this components is as below:

Talend_tFileInputDelimited Component

The next step is to make this input data iterable. Talend has a component for this also: tFlowToIterate. This component converts Main flow to iterate flow. It iterates input and converts into global variables. These global variables can be used later to access the data individually from the input file. The surprising thing is that you don't even have to do any kind of configuration. Everything will be handled by this component only.

Once you use the tFlowToIterate, it will convert your data into an iterable form. And, you can't put this data directly into a file. Even if you use tFileOutputDelimited component and try to link tFlowToIterat to tFileOutpuDelimited, the Talend won't accept it. You need to convert your data from iterable form to fixed form so that it can be put into a file. And, no surprise, Talend has a component for this also: tFixedFlowInput.

tFixedFlowInput component requires config settings. First, define the schema, it will be same as defined in the input file. As soon as you define the columns the same will be populated in the COLUMN section. To map the values, go the value column and hit CTRL + SPACE. This will give you the list of all global variables. Select your global variables from the list.

Once everything has been set, your component settings will look like this. Notice, these values are the global values. Using these global values, we can access the data available in the specific column.And, we haven't done anything extra to set these values, just picked the right values from the drop down list. Talend makes it very easy.

So, once you get all values, you just have to set these values in the output file. To put the values in the output file, we are going to use tFileOutputDelimited component. You could have guessed it by now how the output will come out with the CITY name. We already have the global variable for the CITY column. We will use this global variable to generate the output file.
File Name : "C:/TalendTesting/TestingFiles/"+((String)globalMap.get("row1.CITY"))+".txt"

There could be multiple values linked to the same CITY. And, we want all CITY data to be clubbed in one file. To enforce this, please check the APPEND checkbox. Otherwise, each time when the Job encounters a CITY, it will create a new file. To check this scenario, I will add one more entry for PUNE city.

Component Details:

tFileInputDelimited :

tFileInputDelimited reads a given file row by row with simple separated fields. Opens a file and reads it row by row to split them up into fields then sends fields as defined in the Schema to the next Job component, via a Row link.

Get more details from here: tFileInputDelimited Component Detail

tFlowToIterate :

tFlowToIterate iterates on the input data and generates global variables.This component is used to read data line by line from the input flow and store the data entries in iterative global variables.

Get more details from here: tFlowToIterate Component Detail

tFixedFlowInput:

tFixedFlowInput generates as many lines and columns as you want using the context variables. It allows you to generate fixed flow from internal variables.

Get more details from here: tFixedFlowInput Component Detail

tFileOutputDelimited:

tFileOutputDelimited outputs data to a delimited file. This component writes a delimited file that holds data organized according to the defined schema.

Get more details from here: tFileOutputDelimited Component Detail

Final Job Design:

Talend_FinalJobDesign

Final Job Execution:

So, once I execute this Job, I should be getting 3 files for each CITY. And, for the PUNE city, my output file should have two records.

Talend_FinalJobExecution

The Output:

Talend_FinalJobOutput

Talend ETL Tutorial : How To Find Jobs Containing Specific Component

2016-12-18T03:53:00.000-08:00

Image Source : freepik

Ever wondered how could you find the specific component used in the heap of Jobs? This is required for a lot of reasons. You may want to trace the filenames that you have used in some specific components (eg: tFileInputDelimited ) but there are already 100 Jobs in the environment and you are not sure how many Jobs are actually using this component. So, you don't have any filter criteria. The last option would be to check all the Jobs one by one. But, what if you can apply some filter to get at least those Jobs which are actually using this specific component?

Steps To Check For Specific Component In A Job:

You may have a lot of Jobs under Talend Repository. The count could be anything. In my Talend Job Designs, I have these many Jobs as of now. And, I am not sure what components are being used in all these Jobs.

Talend_RepositoryJobDesign

Now, Go to Palette's Seach bar. And, search for your component. Or, if you know the exact folder location of the Talend component, you can directly go to the component. In this demo, I am searching for the tFileInputDelimited component. As you can see in the below screenshot, I have searched with tFileInput and got the list of all components where this string (tFileInput) has been used.

Talend_PaletteComponentSearch

So, the tFileInputDelimited component is under File -> Input directory. Right click on the component, and go to Find Component In Jobs option.

Talend_FindComponentInJobs

As soon as you click on it, Talend will scan all the Jobs available in Job designs and give you the list of the Jobs where this specific component is being used. In this case, Talend has given me the list of all Jobs where tFileInputDelimited component has been used.

Talend_SearchedJobDesigns

This may seem unimportant at the first sight but you will only get to know the importance of this feature when working in a real environment. I have worked on Datastage before there you may have options to find the Job but not any specific component. There were numerous occasions when I was craving for the feature like this. Fortunately, Talend provides this option and this feature is very helpful and useful.

Talend ETL Tutorial : How To Declare And Use Variables In A Job

2016-12-17T07:18:00.000-08:00

Variables are the soul of any program. As a programmer, we never code with the static values. Also, the main aim of any program to minimize the redundancy and repetition of the same thing. The Variables make it possible by storing the values dynamically. In Talend world also, we have variables concept and like in any other programming language, it also has the concept of Local and Global variables. The Local variables are known as Context Variables in Talend. A context variable is a variable which is defined by the user for a particular context.

Let's Explore Contexts..

Depending on the circumstances the Job is being used in, you might want to manage it differently for various execution types, known as Contexts (Ex: Prod and Test environments). The simple example is, testing environments where we have to run the jobs for different instances. You can consider all these testing environments as Contexts. You can set your Job to run in all these Contexts once you set the variables for it.

How To Define Context Variables For A Job :

There are mainly TWO ways to define variables for the job...

Define Variables Through Context View:

You can find the Context View among the configuration tabs and below the design workspace.

Talend_ContextView

In simple words, It's more of Job Properties as used in Datastage. In this window, you can define all the parameters value that are going to be used in your Job. Just define it once, so that you don't have to define it again and again.

Talend_SetContextVariables

To define, new environments or contexts, you can just click on the PLUS button as shown in below screenshot.

Click on New button, and give a name to the new contexts. You can give different contexts names for different environments. You can define the default contexts here, also set the position using UP /DOWN button.

Now, the new context would be as shown in the below screenshot. Same way, you can set contexts for different environments.

Talend_NewContextGotAdded

The next step is to set and define variables for the Context view, Just press the Plus button at the bottom of the Contexts tab. Set the Name, Type and Values for the variables. These values can be different or same based on your requirement for different environments.

Talend_SetVariablesInContextView

If you want to display prompt for variables before running the Job, Just check the box and mention the prompt name in the next column.

Define Variables Through Component View:

This is the quickest way to define a single context variable. You can parameterize any field using this.

Go to the component settings which you want to parameterize. In this example, I am going to use tFileTouch component. This component requires File Name value to execute. So, Instead of providing the File Name directly, I will parameterize this field using a variable.

Go to the field which you want to parameterize and press F5.

Hit finish button and you will be back to component config window. Now, you will be able to see new value in File Name text field.

The same will get added to the Contexts tab of the configuration tab automatically. You don't need to come in the Contexts view tab and define the parameters individually. That's why this method is the fastest way to create a single contexts variable.

If you want to change the file name or the directory, you can do it while running the Job. As we have set the prompt for the file name, Talend will ask you for the filename before running the Job. The benefit of using variables..

Talend ETL Tutorial : How To Use System Routines And Generate A File With System Date

2016-12-14T10:23:00.000-08:00

In most of the ETL tools, we have the option to create routines. The language used to write these routine depends on the ETL platform.Like on the Datastage, it's the bash script. In Talend language, the routines are well written Java code which is required to do some specific task. The routines are small Java code snippets that we can directly use in our Job design. In Talend, You can use the System defined routines or if you are not able to find the routines based on your requirement, you can always define a new one.

Requirement

The requirement is to add the timestamp as a suffix while generating the output file using Talend System routine.

Steps To Use System Routine In Talend

Talend offers two kinds of routines: System and User. The System routines are already existing routines in the Talend. these are classed according to the type of data which they process: numerical, string, date. The User routines are defined by the user either by updating current System routines or by creating new from scratch using Java code.

Where Are The System Routines?

To access the System routines, Go to Repository -> Code -> Routines-> System. In the below screenshot, I am using TalendDate routine. Once you click on the TalendRoutine, you will get the complete Java code for this routine in the code window. Also, if you check on the left side, you will find all the methods used in this routine at the bottom of the window.

Now, the requirement is to append timestamp as a suffix in the generated file name. For this demo, I will create a simple Job. Talend has a component to generate a blank file: tFileTouch component. This component will help you to generate a new file. You can mention the directory and file name and based on your input, this component will create the blank file under specified folder as per the requirement. You can find this component under File -> Management -> tFileTouch.

tFileTouch Component Details:

tFileTouch either creates an empty file or, if the specified file already exists, updates its date of modification and of last access while keeping the contents unchanged. This component creates an empty file or updates the details of an existing file for further operations and creates the destination directory if it does not exist.

Get the more details here: tFileTouch Component

How To Use System Routine ?

Now, let's configure this component. I will browse for any existing file and will add the timestamp using TalendDate routine. You can also create a new file and directory. Just mention the path and file name and check Create directory if it doesn't exist box.

Once you browse and select your file, it will come like this.

Now, as per the requirement, I will remove the file extension and will add an underscore ( _ ). Next, will add plus (+) sign. Notice the quotes. Hit CTRL + SPACE and you will get a lot of options to choose from.

If you scroll to the bottom, you will find a lot of methods, tagged as TalenDate. Based on your requirement, you can pick a value from the list. You can also play with the different methods and check what's the outcome. As I have to attach timestamp, I will go with the GetDate() option.

But, on windows platform, you have to remove colons(:). So, your GetDate() value would be TalendDate.getDate("CCYY-MM-DD hhmmss") in place of TalendDate.getDate("CCYY-MM-DD hh:mm:ss").

Final Job Execution :

It's time to run the Job now. Let's see the Job execution in action:

Talend ETL Tutorial : How To Replace Blank Value With Default Value In Input File

2016-12-11T08:50:00.002-08:00

Sometimes, we don't get the proper records in the input file. Some columns come as blank. Based on the requirement, we may have to fill those blank values with some values. As we can't manipulate the records in the input file, we have to handle it in the Talend while processing it. One scenario could be to replace blank values as NULL.

Requirement

The requirement is to replace the blank values coming in the input file with default values. The input file layout is as shown below :

Steps To Fill Up Blank Values With Default Values

First of all, we are going to read this file using tFileInputDelimited. As I already discussed, we need to define the schema before reading any input file.
To Define the schema , Go to MetaData -> FileDelimited -> Create File Delimited. Give any name as per your requirement and click on Next.
Browse for the file and select the Format as per your OS. Click Next.
As I am getting the Header columns in the input file only, I have checked the Set heading row as column name. As soon as you check this box, the Header in the Rows To Skip section will automatically be get selected.

You can see in the above screenshot, the input file records got properly structured in the table format and it's easy to identify Blank column here. It's Company and City column. You may have the requirement to fill these columns with some default values instead of leaving it as blank. I am going to take NULL string as filler. Don't be confused with NULL string. It's not a NULL value. The NULL string, in this case, is similar to any other string value like XXX or YYY.

You can put any value as per your requirement. Also, as the column type is String, I am putting these values in double quotes otherwise Talend will throw an error.

The Final Job :

As expected, the blank values got replaced with NULL string.

Talend ETL Tutorial : How To Skip Header And Trailer From A File

2016-12-10T08:52:00.000-08:00

Each input file follows a standard layout. Normally, each input files comes with Header and Trailer records. The Header and Trailer records give some additional information about the file Ex : When the file gets delivered and what is the record count in the file. But, while processing the file, the Header and Trailer records are not required. And, we only have to deal with the Detailed records present in the file.

Requirement

The requirement is to skip Header and Trailer Records from an input file.

Steps To Exclude Header And Trailer From File

First of all, we are going to read this file using tFileInputDelimited. As I already discussed, we need to define the schema before reading any input file. And in this case, we will use specifically Repository schema to read the file.
To Define the schema , Go to MetaData -> FileDelimited -> Create File Delimited. Give any name as per your requirement and click on Next.
Browse for the file and select the Format as per your OS.

Now, in the next screen, we have to do some changes based on our requirement. As you can see my input file is the delimited one and the delimiter is SPACE. I will let the Talend know to split the columns based on the SPACE. Also, to exclude the Header and Trailer , just check the Header and Footer checkbox and put the count as 1. Click on Refresh Preview.

The Column name and Column type will be automatically selected. If you are not satisfied with it, you can modify it based on your requirement in the next screen. Once done, click Finish and that's it !!

Once you are done with the Metadata, the next step is to select it while reading the records. As we are using tFileInputDelimited component to read the file, we have to select the Repository schema and then the metadata.

The Final Job Design And Execution

I have used tLogRow component to display the output. If everything works well, we shouldn't be getting Header and Trailer records in the output.

Talend ETL Tutorial : How To Club Different Schema Excel Sheets Or WorkSheets Into One

2016-12-05T08:42:00.002-08:00

In one of my previous posts. I have covered how to read and Excel File. As you already know, the Excel file comes with a structure. We call this structure the Schema of Excel file. When we read Excel file through Talend, First, we define its schema using Built In or Repository option. Now, what if we want to read multiple Excel files or the multiple worksheets present in Excel and all have different schemas. We can't define the fixed schema for these. All we can do is to define separate schemas for separate layout and then find some links to club these records.

Requirement

The requirement is to read different schemas worksheets present in Excel file and club it into a new Excel File. Instead of different worksheets, there could be different Excel sheets also.

Steps To Read Excels With Different Schemas

Let's first explore the Input source. For this demo, I have created an excel file InputExcel. It has two worksheets with different schemas. The first sheet has columns as Name, ID and Score whereas in the Second sheet, we have columns as ID, Department.

In both sheet, we have a common column ID. We are going to use this column to match records from both worksheets and use this to club data and output the records in a new excel file.
First thing first, we have to define schemas for our Input source. As we are dealing with two schemas, we have to define two different schemas. I have defined Repository schemas for this.

The process of defining the schema is same. For the TalendTestingInputExcel metadata, I have selected the FirstSheet as the worksheet and for TalendTestingInputExcel_Sheet2 metadata, I have used SecondSheet as the worksheet. Now, I don't have to define these schemas later while configuring the component. I can just use these schemas and everything will be populated automatically in Talend.

Now, the next question, how to link these two worksheets ? For this, we are going to use a new Talend component tMap. It's more like a Transformer of Datastage ETL tool. You can transform and manipulate data using tMap component.
Using tMap component, we can join the record based on ID column and extract the required fields.

In the above screenshot, I am linking both worksheets based on ID column. You just have drag and drop the row1 ID column in front of row2 ID column. By default, the join is Left outer join. But if you want, you can change it to Inner Join based on your requirement.

The final piece is to configure the tFileOutputExcel component.

The Final output would be like this :

The Final Job Execution

Talend ETL Tutorial : How To Execute Multiple SubJobs In Parallel

2016-12-03T10:01:00.000-08:00

In the last post, I covered how to iterate through files in Parallel execution mode. But what about the jobs that we create in our design. Can we execute jobs also in Parallel ? Let's check in this post how we can do it...

What Is Parallel Execution ?

Parallelization in terms of Talend Jobs means to accomplish technical processes through parallel executions. When properly designed, a parallelization-enabled technical process can be completed within a shorter time frame.

Requirement

The requirement is to run the already created jobs in parallel. The execution mode must be in Parallel. So, instead of running the jobs individually, we will combine two jobs and run them simultaneously.

Steps To Execute Jobs In Parallel

You must have some Jobs in Talend so that you can enable the Parallel execution mode for it.
I am going to use the Jobs that I have created and explained in my earlier posts.

The First Job : How To Combine Multiple Files Into One

The Second Job : How To Read Multiple Files Using Talend

We will create a new Job in Talend Open Studio designer and will use two tRunJob components to call two Jobs. I have used the tRunJob component in one of my previous posts. Please get the details in this post : How To Use tRunJob Component

First, Set the Calling Jobs In Parallel Execution Mode :

It's a simple step. Just go to the called Jobs and open the Designer. Go to the bottom section of Talend Open studio designer. Now, Go to Extra and Check Multi Thread Execution box. Do this for all the jobs that you are planning to call.

Now, once the above setup is done. Do this for your new job design where the child jobs are being called. I have named this new Job as HowToExecuteJobsInParallel. Now, I am doing the same setting here also.

That's it !! The Jobs are ready to run in Parallel Execution mode. If you want , you can link the tRunJobs and make them run one after other but you have to link using some condition like OnSubJob Ok. If you are not linking it, then both tRunJobs execution will happen simultaneously as explained in this demo.

Talend ETL Tutorial : How To Iterate Data In Parallel Mode In Talend

2016-12-01T10:00:00.000-08:00

Requirement :

The requirement is to iterate through through the multiple files present in a folder and display the content of files. Also, the execution must be in parallel.

Steps To Iterate In Parallel Mode :

I have already covered a post to process multiple files present in the folder.You can check the post here. But, the execution was not in parallel mode.

How To Read Multiple Files Using Talend

I am going to refer the same Job and will make it run in Parallel mode.
The steps are very simple and you don't have to do anything fancy for it. Just click on the iterate link.

As you click on the link, you will be able to see the Enable Execution box at the bottom section of the Talend studio designer.

If anyhow you are not able to get this window after single click on the Iterate link. You can try another way. Right click on link -> Settings. It will also give you this window.
The next step is to check this box. Once, you check this box , you will get another option. In this option, it will ask you about the Number of Parallel Execution. Based on your requirement, you can mention the numbers of execution.
In this demo, I am reading 4 input files so I will set the execution number as 4.

How To Identify The Execution Mode Of Jobs :

You can easily identify the Iteration execution mode just by looking at the job when it's running.

Iteration Isn't In Parallel Mode :

In this job, the iteration mode is normal. You can compare this screenshot with the parallel execution screenshot and get to know what's the difference between these two.

Iteration Is In Parallel Mode :

When the iteration happens in parallel mode, the iterate link gets suffixed with the execution number. As in this job, I have declared the Number of Parallel execution as 4. The same got suffixed with the iterate link. Also, for each file read (execution), there is a separate thread.

Talend ETL Tutorial : How To Define Schema At Runtime in Talend

2016-11-30T08:28:00.002-08:00

You must have faced a situation in your Job designing career where you have to deal with an ever-changing schema of the input source. Whether the data coming from a database or a simple input file, you can't define the metadata for it. When you don't define schema, the system won't be able to read it properly.The only solution to this problem is to define Runtime schema. The Runtime schema is being created and read at the run time. But, the question is how to do it in Talend ?

Requirement :

The requirement is to read the data from a table and store it in a file. And, the table structure is unknown. Means, we can't define the metadata structure.

What is Dynamic Schema ?

Dynamic schema allows you to design Jobs with an unknown column structure (unknown name and number of columns). If necessary, dynamic columns can be mapped directly to the target using Pass-through mode. For example, if you need to migrate a whole database with hundreds of tables, you can do so without explicitly including the table structure, using a single Job.

Can we define schema at Runtime ?

The Short answer is NO. We can't define a dynamic schema. All schema must be defined at the time of component designing whether Repository or Built In.

But, there is one feature available in Talend Open Studio Enterprise version , not in the Community version, which solves this problem. I don't have subscribed version of Talend, so, I am going to use screenshots from the Talend's web site.

How To Process Changing Data Structure ?

Read a Table with Dynamic Schema :

In this example, we are going to read and extract the table records and populate an output file without defining the metadata structure.

In Talend Open Studio for Data Integration, the community version, you have to define each column in the schema to map the real table structure. If the table structure is unknown, it is impossible to read the table.

Using this type, you just need to define only one column with the Dynamic type instead of defining all columns.

The Job Design :

The Job design is very simple. Just one tMysqlInput component to read the table from database and one tFileOutputDelimited component to capture the output.

tMysqlInput Component Configuration :

In this , we are going to read a table Person. The query type is Built-in as we are hard coding the statement and also the schema is Built In. Just for the reference, the table contents are like this :

tMySqlInput Schema :

The Talend Community edition requires you to define the metadata for all columns under the Built-In schema but in the Enterprise edition, you can just define the Type as Dynamic and that's it.

tFileOutputDelimited Component Configuration :

You can configure this component based on your requirement. If you want to include table columns in the output, you can just check Include Header box. Also, select Built In schema and just click on Sync columns to use the same schema as used by linked components. In this way, you don't have to define it again and again.

The Final Job Execution :

Once you execute the job finally, it will have the records with the header details as shown below. The one thing to notice here, we haven't defined any schema for the output file.

Talend ETL Tutorial : How To Combine Multiple Files Data Into One

2016-11-26T03:40:00.000-08:00

This is another very common scenario. We have this common requirement of combining data from multiple sources and insert it into one destination. The destination could be one file or database.In this post, I will cover how to combine data from multiple sources. The condition is that the SCHEMA must be same of all the input sources. Talend provides a component for this : tUnite. If you are aware of the Datastage ETL tool then it's more like a FUNNEL stage.

The Requirement

The requirement is to take data from 4 input files, combine it and present it as a single output. For this demo, I will be taking data from multiple files and insert it into one file.

Steps To Combine Data Into One File :

The first step is to take the input files. Based on your input file requirement, you can select the Talend component. As I am dealing with text files in this demo, I will take tFileInputDelimited component. There are two ways to design job for this job.

First Job Design :

In this design, you can take the input files separately and take the tFileInputDelimited component for each file. But this is not good when you have to deal with a large number of files. The benefit of using this is that you can define the order in which the input files should get processed.

Second Job Design :

In this design, you can deal with the multiple files at once. Using tFileList component, you can iterate through the files at once and you don't have to use multiple tFileInputDelimited components.

If you are not sure how to use tFileList component then please check this tutorial :

Learn To Use tFileList Component In Detail

While reading the records from input file, you must define the schema. We can define the schema in two ways either through Repository or Built In option. When you are defining schema through Repository, you always have to describe it first under Metadata and it will get stored there. Whereas the Built In schema doesn't get stored anywhere and you can define it at the time of component configuration.

The next is to use tUnite component, to combine files coming from multiple sources. The one thing that you have to consider here is the schema must be same in all the input files. The component configuration is also very simple. You just have to click on Sync column option to get the schema of the input component.

As soon as you link the tUnite component to another output component(tFileOutputDelimited), the same schema structure would get propagated to the output also.If you don't have any specific requirement of output then you don't have to do anything extra other than just connecting the tUnite component to the tFileOutputDelimited component.

Final Job Execution

Component Used In The Job Designing

tUnite

Merges data from various sources, based on a common schema.Centralize data from various and heterogeneous sources.

Get more details from here : tUnite Component Details

tFileList

tFileList iterates on files or folders of a set directory.tFileList retrieves a set of files or folders based on a filemask pattern and iterates on each unity.

Get more details from here : tFileList Component Details

tFileInputDelimited

tFileInputDelimited reads a given file row by row with simple separated fields.Opens a file and reads it row by row to split them up into fields then sends fields as defined in the Schema to the next Job component, via a Row link.

Get more details from here : tFileInputDelimited Component Details

tFileOutputDelimited

tFileOutputDelimited outputs data to a delimited file.This component writes a delimited file that holds data organized according to the defined schema.

Get more details from here : tFileOutputDelimited Component Details

Talend ETL Tutorial : How To Loop Using Talend Component

2016-11-21T22:16:00.002-08:00

There are multiple scenarios where looping is required. The looping concept is present in all programming language and you must have used it somewhere. The question is how to use it in Talend? Fortunately, Talend provides a lof of looping components for this purpose. And, if any of the components is not able to fulfill your requirement then you can also write your custom code.

Looping Components Available In Talend

tLoop

This component is same as your programming language loop. You can define the Start and End of the loop with the incremented step. It operates on the task execution. It allows you to execute a task or job automatically based on a loop.tLoop is to be used as a start component and can only be used with an iterate connection to the next component.You can loop through either using FOR or WHILE loop.

Get more details here : tLoop Component Details

For Loop Settings :

While Loop Settings :

tLoop In Action

In simple terms, we can use this to iterate a job n number of times. There could be a requirement to execute a specific job multiple times, so instead of calling it multiple times , we can just pass it in the tLoop. So, basically, it works on Parent and Child relationship. The job where the tLoop component is being used, will work as the Parent component.

For the demo, I am going to use one of the existing jobs ( HowToReadMultipleFiles ). This job will work as a child because it will be called by a tLoop job multiple times.

Child Job

Parent Job

Final Job Execution :

tLoop Component :

tRunJob Component :

tSleep Component :

We are going to call our child Job 3 times as per our Loop settings. And in one run , this child job prints 4 lines at the console so it means at the end of our Parent job run, we will see 12 lines of output on the console.

tForEach

tForeach creates a loop on a list for an iterate link. tForeach allows you to to create a loop on a list for an iterate link. tForeach is an input component and requires an Iterate link to connect it to another component. You can insert any value in the double quotes to be iterated upon.

Get more details here : tForEach Component Details

tForEach In Action

For the demo purpose, I have created a simple Job here. We are going to iterate above defined value in the tForEach settings. Will just display the records on the console using tJava component. tJava component is required when we have to write our custom code. As you could have guessed it already, this should be written in Java.

tJava Component

This component has an only window : Code. You can write your desired Java code here and this component will execute it.

tForEach Job Execution :

tFileList

This component is important when we have to loop through the directories and files. tFileList retrieves a set of files or folders based on a filemask pattern and iterates on each unity. I have covered this component in detail in one of my previous post with the job execution.

Please find the detail here : Job execution with tFileList component

Talend ETL Tutorial : How To Read Multiple Files Using Open Studio Designer

2016-11-20T08:02:00.001-08:00

Till now, we have been reading single Excel and Delimited file. In this Talend tutorial for beginners, we will be reading multiple files using tFileList Talend component.

Requirement :

The requirement is to read multiple text files present in the folder. In this demo tutorial, we will read multiple files available in a folder, pass these files as input and read the contents of the files and display the contents on the console.

Steps To Read Multiple Files At Once :

Let's have a look at our input files first. For this demo, I have created a folder and put 4 four files under it. You can write anything under it. All these contents will be displayed on the console once we run our job.

As far as the contents are concerned, I have put just one line in all input files.

The final job design will be as shown in the below screenshot. As you can see in the screenshot, I have created a new job HowToReadMultipleFiles. The job creation process is same as used in the previous tutorials. I have used only 3 components here : tFileList_1, tFileInputDelimited_1 and tLogRow_1.

First thing first, to read multiple files, we have to configure the tFileList_1 component. Browse for the directory where your files are present. Next, you have to select FileList type, you will get 3 options ( Files, Directories and Both) in the drop down list. Based on your requirement, you can select any one of it.

Global Parameter To Consider While Using tFileList_1 :

As we are reading the files dynamically, we have to pass dynamic values instead of fixed file name.

Global parameters help us to resolve this problem. Based on your requirement, you can take any of the values and use it to the files dynamically.

((String)globalMap.get("tFileList_1_CURRENT_FILE"))

This variable holds current file name without complete path.

((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

This variables holds current file name with complete path.

((String)globalMap.get("tFileList_1_CURRENT_FILEEXTENSION"))

This variable holds current file`s extension, if file has no extension then it will return null

((String)globalMap.get("tFileList_1_CURRENT_FILEDIRECTORY"))

This variable holds only directory name with path exclude file name.

((Integer)globalMap.get("tFileList_1_NB_FILE"))

This variables holds the number of files listed by tFilelist.

In my job design, I use ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")) as the file name must be there with its directory path. The System must know where your files are located. This parameter is being used in the tFileInputDelimited component. As this is the place where we mention the input file names and path. If you want to read excel files then you can use tFileInputExcel in place of tFileInputDelimited..

You don't have to do any modification in tLogRow. Just link this component with the tInputFileDemilited component and rest will be taken care of automatically.

Talend Components Used In the Design :

tFileList

tFileList iterates on files or folders of a set directory. tFileList retrieves a set of files or folders based on a filemask pattern and iterates on each unity.

Get more details from here : tFileList Component Detail

tFileInputDelimited

tFileInputDelimited reads a given file row by row with simple separated fields. Opens a file and reads it row by row to split them up into fields then sends fields as defined in the Schema to the next Job component, via a Row link.

Get more details from here : tFileInputDelimited Component

tLogRow

Displays data or results in the Run console.tLogRow is used to monitor data processed.

Get more details from here : tLogRow Component Details

The Final Execution Of Job :

HealthCare Management Certificates

2016-11-11T22:46:00.000-08:00

If you are working in HealthCare Domain then you should try these HealthCare Management Certificates. These certificates will give you the basic and advanced understanding of the Healthcare domain. The courses are structured to cover each topic belong to Healthcare domain.As you move up to the hierarchy of certificates, you will be introduced to the much more advanced knowledge of HealthCare domain. These Healthcare Management Certificates are good for your career as well as for your knowledge.These courses are brought to you by the Academy for Healthcare Management (AHM). Sponsored by America’s Health Insurance Plans and the Blue Cross Blue Shield Association, AHM relies on both associations’ decades of experience providing continuing education for health insurance plan professionals. AHM serves more than 1,300 health insurance plans caring for and providing coverage to more than 200 million people.

For latest updates, you can always visit the official website : Official Website

Academy For HealthCare Management

This course will get you up to speed on the basic concepts of healthcare management and its various types of organizational structures. You will learn about major operational areas of health insurance plans as well as legislative, regulatory, and ethical issues that affect the industry.

Please register here to enroll in this course : AHM 250 Certificate
Course Cost :

$255 for Non-Members
$195 for AHIP Members

Once the registration gets completed, you can log in and download the book for this course.

Professional, Academy For HealthCare Management

When you earn the Academy for Healthcare Management’s PAHM designation, you show professionals in the industry that you have a thorough grasp on of the fundamental building blocks of health insurance plans and their functions. You have to register for this also as mentioned above.

Fellow, Academy For HealthCare Management

Take this course, if you’re looking to position yourself as a seasoned healthcare management professional, the Academy for Healthcare Management’s FAHM designation program offers in-depth coursework focusing on specific operational areas. By pursuing this designation, you’ll gain a thorough orientation to current Healthcare developments.

The certificates that you need to complete to get this designation :

Healthcare Management: An Introduction (AHM 250)

You can get the details above.

Governance and Regulation (AHM 510)

This course describes the formation, types, and structure of healthcare management organizations. Along with the role of healthcare management in government-sponsored programs, you’ll learn the overall purpose and direction of healthcare management, the impact of fraud and abuse, and the role of public policy.

Get the details here : AHM 510

Health Plan Finance and Risk Management (AHM 520)

Get a comprehensive look at health insurance plan finance. You’ll learn about financial management techniques, funding, risk management, provider reimbursement, plan risk, pricing, underwriting, and rating methods.

Get the details here : AHM 520

Network Management (AHM 530)

Learn about the network management function in health insurance plans as this course provides you with insight into both network development strategies (risk management, recruiting, selection and contracting) and network maintenance strategies (managing provider performance and feedback). You’ll also learn about considerations for different types of networks.

Get the details here : AHM 530

Medical Management (AHM 540)

Explore medical policy and technology evaluation, appropriateness of care issues, authorization systems, and clinical practice guidelines. With this course, you’ll discover focused strategies for utilization management, including clinical paths and disease management. Quality management (QM) methods and strategies are also described.

Get the details here : AHM 540

Udemy course Featured :

Medical Coding, ICD-10-CM Training, Take this course to prepare yourself for the transition to ICD-10-CM. Learn medical coding and prepare yourself for today's healthcare workplace.

Managed HealthCare Professional

This is the biggest in this series. You must have an understanding of below mentioned Healthcare management courses for Managed HealthCare Professional. You need to complete below HealthCare certificates :

Fundamentals of Health Insurance, Part A (Basics of Health Insurance)

This online course is the place to start to master basic concepts and terminology of the health insurance industry. You’ll get a comprehensive overview of the business environment of insurance companies; learn about the various kinds of health insurance; and develop a working knowledge of how the insurance industry works, including contract provisions, underwriting, sales and marketing.

Get the details here : Part A Details

Fundamentals of Health Insurance, Part B (Basics of Company Operations)

This online course is a survival guide when it comes to understanding health insurance operations. You’ll gain a thorough introduction to business basics, including issuance and installation of policies; policy renewal and changes; premium billing and payment; claims administration; pricing; and state and federal regulation of insurance. Recently expanded and now offered in a convenient online format, this course brings you up to date on new developments, such as wellness programs, the medical home concept.

Get the details here : Part B Details

Healthcare Management: An Introduction (AHM 250)

Same as described above.

And , one of the following electives :

Health Insurance Advanced Studies, Part A

Broaden your knowledge of health insurance with this all-inclusive course. The interactive online curriculum will enhance your knowledge on a full range of topics within health insurance, including plan structures and alternatives, ACOs, Exchanges, Consumer-Directed Health Plans, employer rules, Medicare and Part D, Medicaid, tax treatment of medical expenses and high-benefit plans, HSAs, and planning tools including fraud detection.

Get the details here : Advanced Studies Details

Dental Benefits, Part A : An Overview of Dental Benefits And Dental Plans

Gain insight into why and how dental benefits and current trends evolved. This course provides you with an understanding of the types of dental plans, the similarities and differences between dental and medical insurance, as well as information on coverage inclusions and exclusions.

Get the details here : Dental benefits And Dental Plans

Fraud, Part I ( Introduction )

You’ll gain valuable insight from this broad overview of health insurance fraud. This self-study course focuses on investigative methods for detecting fraud and delves into the many areas in which fraud occurs, including fraud and abuse by providers, consumers, agents, and others.

Get the details here : Fraud, Part 1 Details

5 Screen Recorder Apps For Android , NO ROOT Required

2016-11-08T10:26:00.000-08:00

There are multiple scenarios where you want to capture your mobile screen. This could be recording your game play, videos, images or for any tutorial. But, the main question is how? There are so many apps in the play store to complete this task. But most of the apps require rooting before recording your phone screen. Rooting requires super user privilege and you may crash your phone while doing so. So, I am going to cover the best 5 apps to record your screen which doesn't require ROOTing.

Sample Of Android Screen Recording :

Mobizen Screen Recorder :

Mobizen is the most easy-to-use, convenient screen recorder that allows you to record, capture and edit. It also offers a lot of editing features (Trim, Cut, Images etc..). You can record the screen without any watermark. Anyone can use it with No rooting starting from OS 4.4!!

Estimated Installs : 10,000,000 - 50,000,000

Download the app from here.

AZ Screen Recorder

As of now, I am using only this app for the screen recording. This app is very nice to use and gives you the high-quality videos. AZ Screen Recorder is the best app to record the screen of your Lollipop. It does NOT require root access, no time limit, no watermark, ad-free and very easy to use with one action to start and stop recording. This screen recording app will let you make beautiful screencast videos by providing every feature that you need in a simple and elegant user experience design.

Estimated Installs : 5,000,000 - 10,000,000

Download the App from here.

Rec Screen Recorder :

This app has mixed reviews on the App store. Go for it, if it suits you. REC Screen Recorder PRO is perfect for gamers who want to record their gaming sessions to create tutorial videos or even just to show off. An app developer will find our screen recorder app very useful to create an app video for their apps. Perhaps you are chatting face to face with your friends or family and want to record it to replay it later? There are tons of others situations where REC Screen Recorder PRO can help you.

Estimated Installs : 1,000,000 - 5,000,000

Download the app from here.

Udemy Course Featured :

The Complete Android 7 App Development , this course will teach you everything which you want to know about the android app development. From layouts to Ad integration. Click the below screenshot to navigate to the course.

ADV Screen Recorder :

This is another Screen recording app which doesn't require rooting. Need to record your screen in an easy way and without a menu that covers your whole screen?ADV Screen recorder was designed to be fully featured, without any kind of restrictions and without requiring root.

Estimated Installs : 1,000,000 - 5,000,000

Download the link from here.

Game Screen Recorder :

Use this app for the gameplay recording. It has some cool features specifically for game recording.You can set the transparency of the record button in recording, you can even upload your own picture to customize the Record Button.if you don't want to show the Record Button, just turn off the "Stop by Record Button".

Estimated Installs : 500,000 - 1,000,000

Download the app from here.

Techie's House

Privacy Policy For Racoon Bubble Shooter

Privacy Policy

Talend ETL Tutorial : How To Do Data Validation Using tSchemaComplianceCheck Component

Talend ETL Tutorial : How To Check For Reject Row Option In Talend Components

Talend ETL Tutorial : How To Run Talend Jobs Externally (Without Talend Open Studio)

Talend ETL Tutorial : How To Run Jobs In Sequential And Parallel Mode In Talend Studio

Thanks for your visit !!

This article has been moved to new website :

Talend ETL Tutorial : How To Run Jobs In Sequential and Parallel Mode

Talend ETL Tutorial : How To Implement Right Outer Join Functionality In Talend

Requirement

Final Job Design:

Steps For Processing:

Talend ETL Tutorial : How To Extract Records From Multiple Sheets Of Different Schemas In Excel

Requirement

Input

Output

Final Job Diagram

Steps For Processing

Talend ETL Tutorial : How To Create Multiple Sheets In An Excel File

Requirement

Input

Output

The Final Job Diagram

Steps For The Processing

Talend ETL Tutorial : How To Filter Records Using tFilterRow In Talend Open Studio

Requirement

The Final Job Diagram :

Steps For The Processing :

tFilterRow Demystified..

The Final Job Execution and Output :

Talend ETL Tutorial : How To Reject Rows From Input File Using Talend Open Studio

Requirement

The Final Job Diagram:

Steps For The Processing

The Final Job Execution:

Talend ETL Tutorial : How To Iterate Data Present In An Input File

Requirement

Steps To Iterate Data Present In Input File

Component Details:

tFileInputDelimited :

tFlowToIterate :

tFixedFlowInput:

tFileOutputDelimited:

Final Job Design:

Final Job Execution:

The Output:

Talend ETL Tutorial : How To Find Jobs Containing Specific Component

Steps To Check For Specific Component In A Job:

Talend ETL Tutorial : How To Declare And Use Variables In A Job

Talend ETL Tutorial : How To Use System Routines And Generate A File With System Date

Requirement

Steps To Use System Routine In Talend

Where Are The System Routines?

tFileTouch Component Details:

How To Use System Routine ?

Final Job Execution :

Talend ETL Tutorial : How To Replace Blank Value With Default Value In Input File

Requirement

Steps To Fill Up Blank Values With Default Values

The Final Job :

Talend ETL Tutorial : How To Skip Header And Trailer From A File

Requirement

Steps To Exclude Header And Trailer From File

The Final Job Design And Execution

Talend ETL Tutorial : How To Club Different Schema Excel Sheets Or WorkSheets Into One

Requirement

Steps To Read Excels With Different Schemas

The Final Job Execution

Talend ETL Tutorial : How To Execute Multiple SubJobs In Parallel

What Is Parallel Execution ?

Requirement

Steps To Execute Jobs In Parallel

First, Set the Calling Jobs In Parallel Execution Mode :

Talend ETL Tutorial : How To Iterate Data In Parallel Mode In Talend

Requirement :

Steps To Iterate In Parallel Mode :

(adsbygoogle = window.adsbygoogle || []).push({}); How To Identify The Execution Mode Of Jobs :

Iteration Isn't In Parallel Mode :

How To Identify The Execution Mode Of Jobs :

The Job Design :