topic Re: Read full table with tOracleInput in Talend Studio

Read full table with tOracleInput

Anonymous — Sat, 16 Nov 2024 03:16:52 GMT

i working with talend in a project and i build a ETL where read a table with tOracleInput. I noted that sometimes this component read incomplete the table. Do you know why? some people say in some forum that it is because oracle is returning query data without doing the full scan. but I need you to read the full table. Do you know how to do it? cheers; Eliana

Re: Read full table with tOracleInput

Anonymous — Mon, 17 Feb 2020 15:50:28 GMT

I think it always ready the whole table according to the sql request you provided.

The issue might be your job.
I think you should allow the job in which you have the tOracleInput to finish before you move to other operations if not compatible

Re: Read full table with tOracleInput

manodwhb — Tue, 18 Feb 2020 14:22:45 GMT

@evallejo , I have not faced this issue, is not that way,if you restrict something in the query then only it s possible to get not full data.

you can check in database backed side ,what query has triggered from Talend.