Questions tagged [talend-mdm]

101 questions
3
votes
0 answers

Getting an error while opening a Talend job?

While opening a talend job I am getting the following error. I am using talend 6.1.1 An error has occurred. See error log for more details.java.lang.NullPointerException Note: when I double click on the job to open, the ln I am getting following…
user8745195
3
votes
3 answers

Common Logging in Talend

I was trying to implement logging in Talend. So I made a job using normal components, I have recorded the error, info and debug through Twarn and Tdie. Using Logcatcher , I am segregating the log into two files of debug and error. This part is…
Deepan Ram
  • 842
  • 1
  • 10
  • 25
2
votes
2 answers

Load the data from MongoDB (tMongoDbInput) of recent rows which are not loaded yet

Background : I have created a job which is reading data from MongoDB and loading that to MS-SQL. Current Behaviour : Whenever I run the job it is fetching all the data from MongoDB . Expected Behaviour : When the job will run it should fetch only…
Lily
  • 605
  • 3
  • 15
  • 31
2
votes
1 answer

Generate specific key for specific code in Talend

i want to generate specific numbers for specific codes in talend. Some of the codes are repeating, but i dont want to generate a different numerical sequence for that code. In tMap i used Numeric.sequence("out1.CODE",1,1) but it didnt help. Is there…
Wmm
  • 139
  • 5
2
votes
1 answer

Usage of Escape char and Text Enclosure

What is the use of Escape char and Text Enclosure in tFileOutputDelimited component and How can we use them?? Thanks in Advance...
Horse_1995
  • 227
  • 5
  • 14
1
vote
2 answers

Any solutions on splitting output file?

I'm a newbie here in Talend and what I am trying to do is to split different output file, here is an example of the file that I am working on... File of Example For example: Whenever I see a column with a true value I need to produce different file…
nel
  • 13
  • 2
1
vote
1 answer

Talend Run If Trigger with context variables

I have a question regarding the output of a job. Would it be possible to make an output of a job dynamic? What I mean is being able to configure a wanted output via a property or something? The user should be able to choose in what kind of database…
Djabone
  • 424
  • 4
  • 17
1
vote
1 answer

How much of Talend functionality is translated in SQL-Query and how much in Java?

I am facing an internship and they asked me to learn how to use talend ETL. I did it, not so difficult. One of the extra-tasks that have been assigned to me is to verify how much of the operations I set on the design workspace is executed in java…
1
vote
1 answer

Alphanumeric Counter in talend to generate id

I am trying to figure out a way in talend to generate an alphanumeric counter that creates numbers in the following way: YYXXXXXXXX Where YY is calendar year XXXXXXXX is id which is alphanumeric counter (starting sequence number 00000001 to…
D3monTw
  • 11
  • 1
1
vote
1 answer

How to append columns to other columns in Talend?

I have two hash inputs, each has completely different columns. Say hashInput_1 has columns called One | Two | Three | Four | Five and hashInput_2 has columns called: Six | Seven | Eight Each hash input has the same number of rows. I just need to…
mastercool
  • 463
  • 12
  • 35
1
vote
1 answer

How to read and write to the same excel file in Talend in the same subjob?

I have a sub job that reads from an excel file and then uses a tMap to edit some of the rows and then outputs it to another excel file. I need to be able to read and write to the same excel file. Is this possible? Maybe there is a component that I…
mastercool
  • 463
  • 12
  • 35
1
vote
1 answer

How do I set the order of execution of my already existing subjobs in Talend?

I have many subjobs in a single job in Talend and I want to be able to pick the order in which they should sequentially execute. How can I do this?
mastercool
  • 463
  • 12
  • 35
1
vote
1 answer

How to change query parameter value of tRestClient

I am new in talend. I am working on this from last 2 days but not able to do it. I want to consume api data into my database. I have this api => http://api.dss.adapt-odisha.com/aagro?url=https://mausam.imd.gov.in/api/nowcast_district_api.php which…
aashu1807
  • 203
  • 3
  • 14
1
vote
3 answers

Generate 1 row from multiple rows Talend

I ve found on the forum exactly the inverse logic of what i need, so i have to ask :) i have fields like this |sector|EmployeeNr|Name|Reason|startTime|EndTime| with this kind of sample…
Reims
  • 477
  • 1
  • 4
  • 12
1
2 3 4 5 6 7