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