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
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.