Scenario based Question in Talend???

Seven Stars

Scenario based Question in Talend???

I have two CSV files.
one file contains address column
second file no address column.
How can I read schema dynamically and store it in db.
Nine Stars

Re: Scenario based Question in Talend???

Sample data with schema details and expected output would help to provide a solution.
Dynamic schema is supported in subscription version of Talend. Link - https://help.talend.com/reader/XYG1yAFeBFz4I4dovmWbsQ/TkXCN1rKY8XzcyFzl72s9A
Seven Stars

Re: Scenario based Question in Talend???

File1:

empno,ename,Dept,sal,sum

File2:

empno,ename,sal,sum

Above two CSV files data .
I have to load two files data into one single table.
while loading if Dept column contains Dept I should load other I should not load.
Nine Stars

Re: Scenario based Question in Talend???

This could be easily done via tMap. Select "Left Outer Join" as your join model & you could set your match key on empno ( guessing this to be primary key sort of).
And for your output just have a output table created and then select all the relevant columns from the two files (left side) to the right side for your output table.

Seven Stars

Re: Scenario based Question in Talend???

My question is.

Some dynamic columns are coming in sometimes.that time how read CSV file and how to do mapping in tmap
Seven Stars

Re: Scenario based Question in Talend???

Hello,

 

Refer to below link , if it solves your purpose.

 

https://community.talend.com/t5/Design-and-Development/tMap-with-Dynamic-schema/td-p/43409

 

Regards

Ganshyam

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog