Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have to do an inner join between two columns,one from HANA and another from MSSQL respectively. But I am not seeing any output. All the rows show up as 0's. Please see the pic attached. Do you guys have any idea what I am missing here?
@Jedi-Habs , whatever the data is there it will show and will not change the data by its wone/ I worked with mysql it will display wah ever the data is there.
Thanks. It is an inner join. And how do I print it out? I tried to see the data from just one source but seeing 0's there as well.
@Jedi-Habs , you have mapped correctly that inner join and now from tmap connect to tlogrow and see the data what are you getting out from the console.
if you are not getting the expected data then your data may be not correct.
Thanks Manod. To your question, I think it's Main. I am doing an inner join and even though for now, I am trying to see the common elements but the eventual goal is to see rejected elements. Check the screen shot I attached in my previous reply. How do I make it to show the real values instead 0's? Thanks.
@Jedi-Habs,since joining columns are character data type and what values are you seeing other than 0 outside of Talend? can you just read one table and see what are you seeing in Talend?
I tried just dumping the from each data source and still seeing 0's. The SQL queries run fine in HANA and MSSqlStudio and I see results there. Why not here?
@Jedi-Habs , whatever the data is there it will show and will not change the data by its wone/ I worked with mysql it will display wah ever the data is there.