I have 2 objects connecting to a tMap. For my test, I've created 3 records on main object A, and 2 on lookup object B. I've also linked a tJavaRow to my tMap to print the rows values. However, instead of getting 3 records, I'm getting 6 (3 from main object A times 2 from object B) :
How to I prevent that? i only want the 3 records from main object A, with related fields of object B. For example like this job:
Solved! Go to Solution.
Thanks a lot vboppudi.
A little nudge in the right direction was all that I needed. I configured a join key in my mapping, and it's working as it should now.
Thank you for your reply TRF. I already configured a join key as suggested by vboppudi. I marked his answer as the chosen answer, because he was the first to comment.
Thank you again.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.