Saturday, 18 January 2025

very Important Questions :-

 SCR:- my source file data Coming Correctly yesterday , today some bad records Length is Exceed in my file without job fail process good records.. how to implement logic in Talend.

Example Job Flow:

  1. tFileInputDelimited
    (Read your source file)

  2. tSchemaComplianceCheck

    • Define your schema constraints:
      • Field Length: Set the maximum length for each column.
      • Data Type: Validate data types (e.g., String, Integer).
      • Nullability: Define whether null values are allowed.
  3. Outputs from tSchemaComplianceCheck:

    • Valid Rows Output: Connect to your main processing components (e.g., database, transformation).
    • Rejected Rows Output: Save to a file using tFileOutputDelimited or log with tLogRow.

  Source File:-




City Having 3 Charter defined as per client requirement , But some one entry wrong data in source i want reject those records process remain records 

Job Desgin:-

Ouput










No comments:

Post a Comment

Scinario Based interview Question .....

 How  To Achieve The Scenario. Input File1.csv  id,Name 1,Mahendra File2.csv City, State Hyd,Telangana File3.csv Stateid Ts I want Out put F...