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
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Practical steps to developing your data integration strategy.