I want to load an excel file into DB , before that I need to check if all the columns are present in the file or not.
Also I want which column is missing.[column names will be same every time I receive a new file].
Load your Excel file into your job using a preset schema, then test using a tMap to see if all expected columns are populated. Load the results into a tHashOutput. If any column is missing (or holding the incorrect type), either fail the job with a message (using a tDie) or simply do not progress to the next SubJob. The next SubJob will take your data added to the tHashOutput and carry on the processing using a tHashInput to read it back in.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema