create staging table in Talend

[Anonymous]

Hi Forum,

I have a Job that has the below Components;

tFileInputDelimited joined to a tReplace Component and this joins to a tUniqRow Component and this all connects to a tMap Component.

All works OK and I have another use for the data that is produced from the tUniqRow Component.

I want to avoid starting all over again from the tFileInputDelimited Component, so I have been trying various other components to do this.

Some Components like tCreateTable won't connect to a tUniqRow or tReplace in order for me to create another output.

I wonder if there's any Component that will hold the results after the tUniqRow Component within the Job.

I want to avoid saving the data to any location, I need it to be a part of the Job.

Hopefully someone has had this issue before.

Thanks   

[Anonymous]

@OscarBoots 

My preference will be file in this case so that I can track the interim dataset in case of failure and I will not clog the memory by holding 10 million records.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂