I made sure the "inner join" is ON for all input tables, and still get NULL vlaues. In fact, before I built this job, I wrote the MySql query in the native DB, and it also returns 2402 rows, all with proper values. Is there a way yo see the resutls of the query (into source/input tables) inside the tMap or anywhere in the Job?

Could a wrong version of Java isntalled on my desktop result in tMySqlinput component to not work properly?

Thanks

Thanks for the suggestion. I did use the Sql query window to verify that all input tables do return all fields (for 100 sample rows). But, even when I simplify my Job to just do an inner join between the Main input table and the fisrt lookup table, and use tMap to join the 2 tables tohgether (with both "Unique match" and "inner join" ON), then send the output to a tLogrow (dispalying only 2 fields, one string, other short interger), the results displayed in the Job execution window still come as null (for string) and 0 for short integer.

Any other ideas? Thx

Attached are a few images:

[img]http://s4scontent.saba.com/S4S_STG_Content/Talend_hotfix_table_query.png[/img]

[img]http://s4scontent.saba.com/S4S_STG_Content/Talend_trail_table_query.png[/img]

[img]http://s4scontent.saba.com/S4S_STG_Content/Talend_tMap_definition.png[/img]

[img]http://s4scontent.saba.com/S4S_STG_Content/Talend_Job_Exec_log.png[/img]

Last edited by bjahansetan (2010-01-26 02:14:07)

Thanks Shomg, that seems to have resolved my Debug Job design issue.
I have a couple more questions questions:

1) The syntax for the equating values in an expression is kind oof wierd though! how come th eexpression builder widget shows "==" as the equate qualifier and is actuality one has to use the <.equals("value")> syntax. Is theer alist of these proprietary syntax uses for Talend (there is  notihing about this in the doc set I was able to download).
2) how does won dor "outer" joins between main and Lookup tables, and how do you specify left or right outer join?
3) it  seems Talend is very strict about data-types, for eaxmple in regular mysel, an field with "int" datatype can be joined to a field with "short" datatype, but Talend barfs on this. Is there a way to relax these kinds of enforcements in Talend?

Thanks again for you insights and help ...

Thanks, that worked. As you can tell, I am not Java saavy, but I will read up on Java syntax. I am curious though as to when one should use the syntax in the expression buillder tool?

Also, 2 more questions, as you seem to be very knowledeable on Talend:

1) How can one auto-generate "sequences" so that when writing to tMySqloutput Tables, one can insert an In-Talend generated unique ID, plus all the fields fetched from tMySqlinput tables?
2) can one do things suac has we d oin "stored procedures" (Oracle and MySql) within Talend Design Studio? If not, how can one call (execute) a stored procedure as a sub-job?

Thanks so much.

Thanks, regarding executing SPs, in MySql the SP cannot be presistently maintained in the DB (unlike Oracle), so every time one needds to execute an SP in MySql, one has to do below 2 steps within an active MySql session:

1) source the SP, e.g.
MySql> source <path_to_sp_file>\sp_file.sql

2) upon successfull compliation of SP:
MySql> call <sp_name>();

My question is, how does one perfrom Step 1 from within Talend, and maitain session integrity (with Mysql DD) so that step 2 can happen subsequently?

Shong, you Rule! Thanks so muck for all the tips ...

One last thing I need to be up and running on Talend is how to schedule tasks to run Jobs. I created 2 subsequent tasks in the scheduler Tab, but thye never fired up. I am currently in regulaer Win XP, but am planning to install talend on a Win 2003 Server, so once on server, do  I have to link Talend to the "at" engine or does Talend have it's own scheduler engine. In either case, can you guide me on this last step too, much appreciated...