Talend community forum / Use one MysqlInput indeed 2 for sames lookup

dtournant · 2009-12-14 16:40:42

Hello,
As you can see in picture, i use 2 lookup (it the same example than TIS documentation). I use it just to get all information about localisation, such as id... because tFuzzy give me only one value.
There is not a better way to increase performance?

Uploaded Images

smalleret · 2009-12-16 12:05:29

Hello,

Maybe you can read your lookup before and store it in tBufferOutput.

After, you can load your lookup with tBufferInput component.

Otherwise, if you have the Data Quality option, we have a tFuzzyJoin component for answering to your needs.

Regards,

SeB

joe177 · 2009-12-17 07:08:24

Hi,

i m trying to log the file which contains failed validation records...

ie. i have collected datas from diff tables and do the mapping in tmap.. how the validation to be done in tmap or anyother way to log the failed records (row).

if the validation fails or success total row should go to seperate delimited file.. it should not go error rows only.

i have attached the screenshot as well

In the screenshot if the record failed validation total row should go to tfileDelimitedOutput2 with shown errors.

if it is success the total row should go to tfileDelimitedOutput1.....

Anyone help me.

Thanks in Advance..

dtournant · 2009-12-17 10:06:35

smalleret wrote:
Hello,

Maybe you can read your lookup before and store it in tBufferOutput.

After, you can load your lookup with tBufferInput component.

Otherwise, if you have the Data Quality option, we have a tFuzzyJoin component for answering to your needs.

Regards,

SeB

Thanks.
About tFuzzyJoin, tfuzzy is in the Data Quality group but i don't see tFuzzyJoin ? I have TIS 3.2.1

Joe177 , we don't see your screenshot

buzcrysl · 2012-01-06 07:28:29

I have the same situation, please answer, where I can find the tFuzzyJoin?
I found the TOS of Dara Integration on the page http://www.talend.com/download.php?src=HomePage is this correct version? but i can't find the tFuzzyJoin inside!

Sorry for my English.

JohnGarrettMartin · 2012-01-06 16:46:48

There are multiple components of TIS. you guys probably have TIS Enterprise Edition (EE) This does not include the DQ components such as tFuzzyJoin. If you upgrade your license to TIS Data Qualtity (DQ) you will receive these components with your new client.

buzcrysl · 2012-01-08 18:57:30

How can I upgrade the license?

buzcrysl · 2012-01-09 08:13:21

I wait the answer

buzcrysl · 2012-01-09 09:42:21

Hwo can help me? please.

janhess · 2012-01-09 10:37:48

Contact your account manager at Talend and pay some money.

buzcrysl · 2012-01-09 10:57:00

How mach it cost?

pedro · 2012-01-09 11:02:00

Hi

You can subscribe at Talend.
Then sales department will contact with you.

Regards
Pedro

Announcement

Unanswered posts

#1 2009-12-14 16:40:42

Use one MysqlInput indeed 2 for sames lookup

#2 2009-12-16 12:05:29

Re: Use one MysqlInput indeed 2 for sames lookup

#3 2009-12-17 07:08:24

Re: Use one MysqlInput indeed 2 for sames lookup

#4 2009-12-17 10:06:35

Re: Use one MysqlInput indeed 2 for sames lookup

smalleret wrote:

#5 2012-01-06 07:28:29

Re: Use one MysqlInput indeed 2 for sames lookup

#6 2012-01-06 16:46:48

Re: Use one MysqlInput indeed 2 for sames lookup

#7 2012-01-08 18:57:30

Re: Use one MysqlInput indeed 2 for sames lookup

#8 2012-01-09 08:13:21

Re: Use one MysqlInput indeed 2 for sames lookup

#9 2012-01-09 09:42:21

Re: Use one MysqlInput indeed 2 for sames lookup

#10 2012-01-09 10:37:48

Re: Use one MysqlInput indeed 2 for sames lookup

#11 2012-01-09 10:57:00

Re: Use one MysqlInput indeed 2 for sames lookup

#12 2012-01-09 11:02:00

Re: Use one MysqlInput indeed 2 for sames lookup

Board footer