Read full table with tOracleInput

Highlighted
Four Stars

Read full table with tOracleInput

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

Highlighted
Nine Stars

Re: Read full table with tOracleInput

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
Regards
DGM
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Moderator

Re: Read full table with tOracleInput

@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.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Downloads and Trials

Test drive Talend's enterprise products.

Downloads