Questions tagged [talend-mdm]
101 questions
0
votes
3 answers
Talend Open Studio not opening after installation (JVM error)
I have installed Talend Open Studio (TOS_DI-20180927_1104-V7.1.1M4).
I am getting error -:
Failed to load the JNI shared library "......\jvm.dll"
a) Java & JRE is installed (1.8.0_181)
b) JAVA_HOME & Path of JDK bin is added in added in Environment…

Ashish Chandra
- 381
- 7
- 21
0
votes
1 answer
Talend Extract dynamic input and transpose it
I have an input flow with dynamic number of values in column :
678|32;29;29;46;48
094|2;8;9;9;48;48
the final result I need :
678|32
678|29
678|46
678|48
094|2
094|8
094|9
094|48
Should I use tjava to parse this flow and how to unpivot dynamically…

user6479259
- 47
- 1
- 9
0
votes
1 answer
Issue Installing Talend,No Response
issue is that while configuring and opening the Talend is giving no response and no hovering type scene is happening during mouse pointer will take on i agree options whenever i'm opening no response on clicking to a I Agree button
I'm installing…

Parminder Singh
- 131
- 3
- 10
0
votes
0 answers
Pass params in tRestClient Talend
I'm trying to pass params to a tRestClient but it's not taking this params :
Any help please ?
Thx

user6479259
- 47
- 1
- 9
0
votes
1 answer
An issue of partial insertion of data into the target when job fails
We have 17 records data set in one of the source tables in which we have erroneous data in the 14th record, which causes the job failure. Then, in the target only 10 records would be inserted as the commit size given as “10” in the mysqloutput…

cyb neo
- 3
- 2
0
votes
2 answers
Migrating data from one mysql database to another using talend
The goal is to migrate data from one mysql database to another, my concern is to define a text file that contains the parameters that defines the source database (host, port, databasename, etc.) and also the file parameters of the output…

tchiko
- 56
- 6
0
votes
1 answer
how to change the date format in talend
I have two scenario's,which I couldn't able to solve.
PLZ help me.
Scenario 1:
I've two files Source_1_table(Excel file),Source_2_table(Excel File).
Attached screenshot
I want to compare the source_1 date to source_2 date.
If the source_1 date is…

Naresh AR
- 69
- 2
- 12
0
votes
1 answer
Talend with SQL function seems not to work
I'm using Oracle SQL Developer to test my database request just before I inject this request on my Talend project.
Here is an exampl. I have a request that is working fine on SQL Developer tools but not on my Talend project.
My sql statment has a…

Feres.o
- 283
- 1
- 4
- 16
0
votes
1 answer
converting Big Decimal(15,12) to string
Hi i'am having a input Big Decimal(15,12) value in source in output i am expecting that as string. For example, my source file with value 0.000000000000 by using tmap to convert it into string. "String.valueOf(column name)" for this im getting…

Naseer Sd
- 33
- 6
0
votes
0 answers
Talend Startup error, Talend twebservice component error
I have encountered a problem with one of my twebservice components, which seems to originate from the apache cxf jar. I see the error during startup also.
WARN [org.apache.cxf.bus.extension.ExtensionManagerImpl] Loading Bus extensions via…

zeno
- 11
- 2
0
votes
1 answer
Adding tSetDynamicSchema component in Talend
I am started working on positional parser talend 6.4.1. As i am gone read data from dynamic schema so i need tSetDynamicSchema component to proceed further. But i cant see tSetDynamicSchema component in the Tool. Can anyone help me to add this…

Shashi
- 25
- 1
- 4
0
votes
2 answers
Dynamic loading not working in talend
Not able to load multiple tables, getting error:
Exception in component tMysqlInput_1 (MYSQL_DynamicLoading)
java.sql.SQLException: Bad format for Timestamp 'GUINESS' in column 3
One table works fine. Basically after first iteration the…

syncdm2012
- 445
- 2
- 10
- 22
0
votes
1 answer
Loadind multiple table from source into multiple table into target in Talend
I have around 25 tables to load to target with same structure and which use the same logic for loading. I have prepared one job which does that, but it's a long process to design all the tables.
Is there any way to pass the table name and load to…

syncdm2012
- 445
- 2
- 10
- 22
0
votes
1 answer
Loading data based on condition of target table in talend
I have a table(target) which has 5 rows, one of the columns name:slno have values (12,13,14,34,56), I need to load data from my source table to target based on the max value of target.
Example :
If in the source table for slno column values are…

syncdm2012
- 445
- 2
- 10
- 22
0
votes
1 answer
In Talend,The record with the highest salary for the same employee should have true flag else flag should be false
I have an input as
ID Employee Salary
1 aaa 10000
2 aaa 15000
3 bbb 9000
4 bbb 23000
5 bbb 5000
6 cccc 12000
7 cccc 15000
and I need output as below:
ID Employee Salary …

Lakki
- 1
- 1