Questions tagged [talend-mdm]

101 questions
1
vote
1 answer

Parsing xml with multiple headers Talend

I'm trying to read xml data received which have multiple header Example : 2017
user6479259
  • 47
  • 1
  • 9
1
vote
1 answer

Talend extract xml for each row

In my data source I have records with XML content that I want to extract and duplicate rows : Data Source id | content 100 |
user6479259
  • 47
  • 1
  • 9
1
vote
1 answer

talend how can we estimate taggregateSortedRow recordcount parameter value

We are trying out talend and we wanted to aggregate some sorted data on few keys . Simple enough but when we try to use taggregatesortedrow its asking for Exact number of rows to be specified. I am not sure how any one can input this on the fly.…
vivek ashodha
  • 117
  • 1
  • 2
  • 10
1
vote
1 answer

Connecting talend with Hadoop

I see on product description of talend MDM free version that it supports connectivity with Hadoop however do not see any option on the interface. I need to get the data from S3 and connect it with Talend. Can you please suggest if this can be done…
Vaibhav
  • 107
  • 1
  • 11
1
vote
2 answers

How to update key value in talend with tmysqloutput component

My scenario is like, I have the tMysqlOutput component is like as follows tMysqlOutput ---> Basic settings ---> Action on table is Default and Action on Data is Update tMysqlOutput ---> Advanced settings -----> Use field options I want to update…
Horse_1995
  • 227
  • 5
  • 14
1
vote
1 answer

iOS MDM push notification using Php, not working

i know it's duplicate of this, but this one is not working for me. My Php code to send notification is // Put your device token here (without spaces): $deviceToken = '6hPQc2HvdA20XGlQkznJxlappCrzm3kJccljjOsgF2k=\n'; #base64 encoded // Put your…
Sheshnath
  • 3,293
  • 1
  • 32
  • 60
1
vote
1 answer

How to Get Talend to Keep Table Names in tOracleInput

Is there a way to tell Talend not to remove the prefix of column names especially when they are specified in the query to retrieve data from data source and keep the names mentioned in the query itself? Thanks!
user2597012
  • 581
  • 4
  • 9
  • 28
1
vote
4 answers

Using tab as delimiter in tFileInputDelimited component in Talend Open Studio

I have written an ETL in Talend Open Studio that loads a CSV/TSV file in a database. To do so, I want to provide the delimiter in tFileInputDelimited component using dynamic context load from a text file. I have specified it in the context file as…
Jagrati Gogia
  • 221
  • 1
  • 3
  • 12
1
vote
1 answer

How to merge two tables with same schema in Talend avoiding duplicates?

I have two tables TableA and TableB TableA looks similar to following: customerId | name | email |telephone ------------------------------------------------- 00001 | Anne | anne@gmail.com | 123456 00002 | Ben |…
BlueStar
  • 401
  • 3
  • 9
  • 29
1
vote
1 answer

Unable to call Talend Open Studio tContextLoad in query

I'm trying to a variable I created from the tContextLoad_1 to perform a query. I've successfully loaded the data into the context using tContextLoad_1. For the key I used date and for the value I used the max date returned from the query. However…
codeBarer
  • 2,238
  • 7
  • 44
  • 75
1
vote
1 answer

Unauthorized error in Talend REST Client

I'm using Talend ESB 6.3 version & trying to pull the data from HP ALM to MongoDB. The below is my job, In my job, I've started from "tMongoDBConnection --> tRESTClient --> tExtractXMLField --> tXMLMap --> tMongoDBOutput". In the REST Client…
user3114967
  • 639
  • 5
  • 15
  • 38
1
vote
4 answers

Build option is not working in Talend Job

I'm using Talend ESB 6.3 and creating jobs. I tried to use the build option in working job, but it is not working even it is not showing any error. The above "FileCopyJob" right clicked & selected build option. then clicked "Finish" button,…
user3114967
  • 639
  • 5
  • 15
  • 38
1
vote
1 answer

Import a zipped csv file into Talend

Is it possible to import a zipped csv file directly into Talend Open Studio for Big Data 6.3.0.2, if not would there be any work arounds?
Jess
  • 97
  • 1
  • 2
  • 12
0
votes
1 answer

Sorting on similar values using talend

I have a CSV file I want to group together similar DeptID and sort the MID in ascending order and assign the value of lowest MID to SID who have similar DeptID using talend open studio for data integration. If there is one DeptID, then assign the…
msangel
  • 1
  • 3
0
votes
0 answers

How we can get nvarchar column value from SQL Server in talend

I'm trying to get nvarchar value in Talend from SQL Server but am not able to get it. Attached is the snapshot for these enter image description here enter image description here In SQL Server I have value as testing/АКМЛЛИАА…