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

Four Stars

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

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.

 

 

Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.