topic Re: data not loading from db table in Talend Studio

data not loading from db table

shalinim1 — Sat, 16 Nov 2024 01:18:55 GMT

I have 3 input database tables which is connected to tmap. While running the job, the whole data from main and 1 lookup are loading. And from another lookup only 2 rows are loading. How to get the whole data?

Re: data not loading from db table

manodwhb — Mon, 12 Oct 2020 09:54:36 GMT

@Shalini M , can you show tmap settings and do the leftouter join lookup.

Thanks,

Manohar

Re: data not loading from db table

shalinim1 — Mon, 12 Oct 2020 10:07:35 GMT

@Manohar B Please find the screenshot. row3 lookup is not loading as a whole data.

Regards,

Shalini

Re: data not loading from db table

manodwhb — Mon, 12 Oct 2020 10:09:22 GMT

@Shalini M ,row2,how many records coming?

Re: data not loading from db table

manodwhb — Mon, 12 Oct 2020 10:11:08 GMT

@Shalini M , there is only two records matching from main and the lookup which is giving 2 records.

Thanks,

Manohar

Re: data not loading from db table

shalinim1 — Mon, 12 Oct 2020 10:11:15 GMT

100 records

Re: data not loading from db table

shalinim1 — Mon, 12 Oct 2020 10:15:35 GMT

@Manohar B Then how can I get the whole record from that table?

Re: data not loading from db table

manodwhb — Mon, 12 Oct 2020 10:18:36 GMT

@Shalini M , Are you sure the which table is main? I believe you need to make row4 as main and row2 first lookup and row3 second lookup.then you will get the all records from row4 and which all vendor ids.

Thanks,

Manohar

Re: data not loading from db table

shalinim1 — Mon, 12 Oct 2020 10:19:53 GMT

Okay! will try in that way!

Regards,

Shalini

Re: data not loading from db table

shalinim1 — Mon, 12 Oct 2020 10:29:14 GMT

@Manohar B Still loading only 2 rows.

Re: data not loading from db table

manodwhb — Mon, 12 Oct 2020 10:50:13 GMT

@Shalini M , if your getting 2 records then row4 has only four records or some where you were filtering the query to get only 2 records?

other if you want get all records from row3 make row3 as main.

Thanks,

Manohar

Re: data not loading from db table

manodwhb — Mon, 12 Oct 2020 10:51:42 GMT

@Shalini M , you see in your screenshot it was loading 100 records to tDBoutput right?

Re: data not loading from db table

shalinim1 — Mon, 12 Oct 2020 10:59:09 GMT

Yes, but the part_name column was null except 3 rows. if all the record in row3 would load. then there will not be any null column.

Re: data not loading from db table

manodwhb — Mon, 12 Oct 2020 11:04:24 GMT

@Shalini M ,which means there is no matching records from row3 lookup based on partid, because of it it was giving null column values.

Thanks,

Manohar

Re: data not loading from db table

shalinim1 — Mon, 12 Oct 2020 11:15:52 GMT

@Manohar B Thanks a lot! It worked! 😊

Regards,

Shalini

Re: data not loading from db table

manodwhb — Mon, 12 Oct 2020 11:24:26 GMT

@Shalini M ,Great that you issue is fixed 😊