I will try explain my situation. I have to make the next:
1. Read a file and extract one of the fields (ids).
2. Delete duplicates of these ids.
3. With a SOURCE_TABLE compare point 2 ids with this table ids to filter this data.
4. Fill the TARGET_TABLE only with SOURCE info when the point 2 ids exists in source table.
At the moment, I have this working but when I test with a really big SOURCE_TABLE my ODI crash. I was thinking about if It could be possible make point 3-4 in a loop. I don't find info about how can I achieve this. Can anyone help me?
This is my current configuration (slow with a big source table because the join is too expensive in performance):
English isn't my first language, sorry for the explain. Tell me about if somebody need that I modify some content.
Thanks in advance
Mensaje editado por: user11001616 Fixed posted Image