How to pass parameter to mongodb query in tmongodbinput?

[Anonymous]

Job to create incremental load.

Need to take max date from redshift table and check in mongodb table (greater than redshift table) and load it in existing redshift table.

Tried some job flows, attached below.

Please help me out.

Thanks in advance.

[Anonymous]

Hi,

   Could you please add component screenshots for more clarity? Did you print the data in a tJava and checked whether the date you are taking from Redshift input component is coming correctly?

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

[Anonymous]

Used tjava to print as you said, is this the correct way?

Its giving error like Type mismatch: cannot convert from Object to String

Added redshift below:

[Anonymous]

Used tlogrow to see the output of redshift input, and it gets the max date to output.

[Anonymous]

Hi,

   Could you please print and see whether the data is getting assigned correctly to tFlowtoIterate component by printing the data after tFlowtoIterate using a tJava?

If its working fine, you are getting date correctly. Then next step will be to include the MongoDB component to verify whether the data is extracted properly as shown below.

If all looks good, then add the next component and print the results. If you are stuck at any component, please add the component screenshot where you are getting error. That way we will be able to debug further.

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