I have a requirement like I need to fetch the data from Parent and Child Tables and write it to a file.
How to develope this in talend. please help
Thanks in advance
Are you connecting to database to retrieve records from Child & Parent table? How does you setup the relationship between these two tables - some sample records from both the tables, your expected output and whatever you have tried so far would help.
Thanks for the reply.
I connected to salesforce input to get the data from both parent and child records and store them to 2 fileoutput delimited files.
I was struck here. don't know how to proceed further. I am new to talend.
SalesforceInput (to get parent records) --> Fileoutputdelimited
SalesforceInput (to get child records) --> Fileoutputdelimited
don't know how to join these 2 tables to convert them to specified format.
how could I get the format using tmap and joins
FOrmat I needed was:
I tried out the below things.
SalesforceInput(to get parent records) -> fileoutputDelimited -> Join ---> TfileoutputDelimited
SalesforceInput(to get child records) -> fileoutputDelimited -------|
Outpout of this job is
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables