My question is that, how can I check if the result set of that expression above is exists on other column on the same table? And if exists I will keep it on the right destination column, but if not I will insert it on other column instead?
my component set-up is:
tfilelist -> tfileinputdelimited -> tmap -> tmysqloutput(1&2)
1&2 that meanss that I'm populating the data from source to 2 destination table, one is for delta and one is for full. Only on initial or first run, then after this I have another the same component set-up, but only tmysqloutput2 in the output as that is for delta. Hoing someone can help me out on this?
Solved! Go to Solution.
@iWant2LearnMore,i will suggest you read the source data and load to memory by using tHashoutput and you can read the dame data multiple time do the comparison by using tHashInput.
@manodwhb I will try to consider your suggestion and if woks, then I'll accept the answer/solution.
I'm thinking if this will work on my set-up as I need to update:
@iWant2LearnMore,check ,if it be help in your case.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Find out about Talend's 2019 Summer release
Talend continues to revolutionize how businesses leverage speed and manage scale
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend