Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2014-05-01 07:35 PM

How to design Parent and Child relationship tables using Talend.

I have to establish the relationship between parent and child tables using Talend.
I tried to design but it is not working as expected.
Please suggest the best way to do this.
I am using Oracle_Sequence for my key column in the the parent table.
Labels (2)
Labels
1,087 Views
0 Likes
19 Replies
willm1
Creator
Creator
‎2014-05-02 10:25 AM

I have to establish the relationship between parent and child tables using Talend.
I tried to design but it is not working as expected.
Please suggest the best way to do this.
I am using Oracle_Sequence for my key column in the the parent table.

Could you explain your design issue a little more? Are you trying to use a sequence to load parent and child tables?
570 Views
0 Likes
Anonymous
Not applicable
‎2014-05-02 10:36 AM
Author

Hi Willim,
Thaks for replying to my post..
I have a Act_id in parent table which uses oracle sequence and same Id i need to insert into two child tables..
While inserting it is working as expected.But for update operation,the key value is getting changed.
Both in parent and child tables..
If i change the key to different column ..It is inserting another record in child table.If i process the same file for one more time..
The way i have designed is..I created a tMap and from there i mapped to tables..I used tOracleInput for getting the sequence id value and mapped to the parent and child tables..
If you can provide the steps to design the workflow that would be really great..I am new to talend and trying to learn step by step..
i have selected the Table Action as "Update or Insert" for both the tables..
I have attached my design as an image to this post..Let me know if you need any more details.
0683p000009ME2M.jpg
570 Views
0 Likes
willm1
Creator
Creator
‎2014-05-02 11:05 AM

Looks like you're merging data from your XML with data from your Oracle table that includes a sequence number... Can you share a screenshot of your tMap?
570 Views
0 Likes
Anonymous
Not applicable
‎2014-05-02 11:15 AM
Author

XML is my data source and i will be having multiple XML's to process..
I have attached my tMap and u can observe the seq variable in middle and it is mapped to three tables..First one is parent and other two are child tables..
570 Views
0 Likes
willm1
Creator
Creator
‎2014-05-02 11:25 AM

mcgovardhan - pls do a 'Post Reply' in order to attach the screenshot of your tMap. Thx
570 Views
0 Likes
Anonymous
Not applicable
‎2014-05-02 11:32 AM
Author

Sorry Williams..i was trying to upload image.Due to dimension issue am not able to upload it..
570 Views
0 Likes
Anonymous
Not applicable
‎2014-05-02 11:52 AM
Author

Uploading the tMap Mapping..
570 Views
0 Likes
Anonymous
Not applicable
‎2014-05-02 11:54 AM
Author

Sorry again issue while uploading it ..Attached once again..
570 Views
0 Likes
Anonymous
Not applicable
‎2014-05-02 02:52 PM
Author

Hi Willim,
Did you get chance to check my tMap mapping image in my previous post..Wht is the actual process to implement the relationship between tabels..
570 Views
0 Likes