Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Python Programs
    • Java Programs
    • SQL FAQ’s

Talend tFixedFlowInput

by suresh

The Talend tFixedFlowInput component generates a fixed number of rows from the internal variables. In this section, we show you how to use this Talend tFixedFlowInput to create a table of fixed values.

Talend tFixedFlowInput Example

Drag and drop the tFixedFlowInput component into the job design.

Talend tFixedFlowInput 1

The following screenshot shows the tFixedFlowInput properties in the components tab.

  1. The number of rows: Please enter the total number of rows to generate.
  2. Mode: It has three options, and we show you an example of each Talend option.
Talend tFixedFlowInput 2

Please click on the Edit Schema button and add the required columns to use in this tFixedFlowInput field. Here, we created three columns SNO, Name, and Age.

Talend tFixedFlowInput 3

Use Single Table

Once you click the Edit Schema OK button, those columns have added to the Column section. Under the values, you have to add the values for each column.

Talend tFixedFlowInput 4

For the Talend tFixedFlowInput demo purpose, we added the values. Next, we used the tLogRow to show the result.

Talend tFixedFlowInput 5

Let me run this tFixedFlowInput job.

Talend tFixedFlowInput 6

Use Inline Table

This option creates an inline table. Please use this option to add multiple rows. So, let me add four records to the columns that we created earlier.

Talend tFixedFlowInput 7

You can see the Talend tFixedFlowInput result!

Talend tFixedFlowInput 8

Use Inline Content (delimited file)

Please use this option to use multiple records in a file. You can simply copy all the records into the content section and specify the Row and field separator.

Here, we changed the Schema and added five columns to store the employee information. Next, we added ten records whose row is separated by a new line and field separated by the comma.

Talend tFixedFlowInput 9

Once you run the Talend tFixedFlowInput job, you can see the result.

Talend tFixedFlowInput 10

Placed Under: Talend

  • Talend Download and Install
  • Create a Talend Business Model
  • Create a Talend Job
  • Create a Global Context Group
  • Connect Talend to SQL Server
  • Context Group to connect DB
  • Talend Read Text File
  • Talend Read Excel File
  • Load Text File Data into Database
  • Load Excel Data into Database
  • Export Database Table to Excel
  • Export Database Table to TextFile
  • Export Database Table to XML
  • Export Database Table to JSON
  • Talend Aggregate Row
  • Talend Aggregate Sorted Row
  • Talend Buffer Input & Output
  • Talend Create Table
  • Talend tDenormalize
  • Talend Datatype Conversion
  • Talend tMap Type Conversion
  • Talend Filter Columns
  • Talend Filter Rows
  • Talend tMap filter rows
  • Talend tFileList
  • Talend tFixedFlowInput
  • Talend tForeach
  • Talend Fuzzy Matching
  • Talend Joins
  • Talend tMap Joins
  • Talend tMap Join Lookup
  • Talend tJava
  • Talend tJavaRow
  • Talend tJavaFlex
  • Talend tLoop
  • Talend tMsgBox
  • Talend tNormalize
  • Talend Pivot Columns
  • Talend Replace Data
  • Talend Replicate
  • Talend tRowGenerator
  • Talend tRunJob
  • Talend Rejected Rows
  • Talend Sample Row
  • Talend Sort Row Data
  • Talend SCD
  • Talend SCD Type 2 Manual
  • Talend Unite
  • Talend Unique Row
  • Talend Read Multi-Structure File
  • Talend Parent Child Job
  • Talend Execute SQL Queries
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy