Hi,
I have a requirement in talend. I have identified parent and child records using tMatchmodel component. Now i need to build the logic for assigning the relation in between record to record.
I am adding 3 additional columns as part of my development to create the hierarchy.
- Family ID
- Parent ID
- Child ID
Attached the sample data how it looks like. Highlighted are the ones, I need to generate based on the status. Blue are the ones coming from source.
Please let me know how to implement this and assign the values for familyid, parentid, child id, insert time stamp,
insert time stamp, insert by & update by based on the sample data that I have provided.
Note: I have oracle database for staging tables
