Mismatch in Talend "toracleInput" component result and actual Oracle server query result for same Join Query

[Anonymous]

Hi All, I'm new to both the forum and Talend and looking for some help here....

I have a simple job that reads data in from an oracle table, This is then out to "thdfsoutput" component.
Simple right! Problem is that I have "240690" rows in the table that I'm reading from, and it's loading in "4228" when run in Talend.
If i run the exact same SQL that is in tOracleInput in "Toad for Oracle" client , I get the "240690" I expect.

My Databsae schema, server , port are in sync on both sides

Confused - hope you can help!

Prash

Solution:

I was querying for the Join sub query to count no. of rows using wrong pattern .

The correct way was "with a as ([big join subquery]) select count(*) from a".

Got resolved.

[Anonymous]

Hello,

---

@prashbritto wrote:
Solution:

 I was querying for the Join sub query to count no. of rows using wrong pattern .

The correct way was "with a as ([big join subquery]) select count(*) from a".

Got resolved.

---

Thanks for sharing your solution with us.

Best regards

Sabrina