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