Questions tagged [talend-mdm]

101 questions
0
votes
0 answers

Talend: How to remove a specific XML tag from output when the source file is a .txt file instead of xml

In Talend, I am supposed to remove a particular XML tag from the output when it has a blank value. But the issue is that the source is a .txt file so i am not using an XML tree in the input to work on tags individually. Design is:…
0
votes
0 answers

How to get metadata from Talend Data Management Platform?

I'm building a Data Lineage and for that I need the metadata about the Talend jobs, schemas and tables associated with each job. I went through the documentation but there was only one way to get that data and that was using GUI. I want to automate…
Manan Jain
  • 1
  • 1
  • 2
0
votes
0 answers

How to insert streaming data into snowflake using talend

How to load the data into snowflake using talend, input am getting streaming data from kafka
0
votes
2 answers

talend format yyyy-MM-dd'T'HH:mm:ss.SSSz to yyyy-mm-dd HH:mm:ss

I am trying to change the date format in txmlmap component but its not working i want change date format from yyyy-MM-dd'T'HH:mm:ss.SSSz to yyyy-mm-dd HH:mm:ss expected output:- yyyy-mm-dd HH:mm:ss
0
votes
0 answers

How to change date format in talend txmlmap component

Unable to parce the date parceTodate Error am getting in talend txmlmap component How to parce the date from 2022-11-28T02:24:20.755-05:00 to 2022-11-28 02:24:20 in txmlmap component in talend
prasad
  • 1
  • 1
0
votes
0 answers

using fixed template to load data from Talend

how I can use fixed template in .csv format by loading data from Talend open studio. also, if the column name of the headers has space it shows as _ underscore. how to solve that?
0
votes
1 answer

Dynamic Schema/Type -table column name in camelcase

Dynamic Schema/Type -table column name in the original name I created a job in which I have to read from a DB table and write into another DB table. I have to do this operation for almost 20 tables. So I am using Dynamic Type to achieve this instead…
0
votes
2 answers

Is there any way to import executable JAR file in Talend?

i'm trying to import an Executable jar in talend which i need to process. is there any way to do it?
lanor
  • 1
0
votes
1 answer

API Rest Talend execution promotion : artifactType field

I am currently developing a DevOps process whose goal is to trigger the execution of a promotion pipeline using the Rest Talend API in the case of promoting tasks from one environment to another. In the API documentation…
0
votes
1 answer

How to filter rows based on a condition and if the condition isn't met, grab another row in Talend?

It was hard to think of a title for this question, so hopefully that did make sense. I will explain further. I have a flow of data from an Excel file and each row has one of two words in the last column. It will either contain "Open" or…
mastercooler6
  • 377
  • 2
  • 16
0
votes
1 answer

How to count the number of rows in a flow in Talend?

I am trying to get the number of rows in a flow in Talend. I have a subjob that looks like this: How can I get the number of rows from this flow (where the red arrow is) and write that value to another document or store it in a variable. I know I…
mastercool
  • 463
  • 12
  • 35
0
votes
0 answers

How to give stored procedured name dynamically in Talend tDBSP

I have a table name called abc in oracle db, which has two fields S.No, and procedure name. I am calling the S.No and procedure name, where SNO is input given by me (while executing the job, it asks for S.No). Once I get the procedure name related…
user1620464
  • 39
  • 1
  • 2
  • 11
0
votes
2 answers

How to make multiple rows from one row in Talend?

I have data that looks like this: Name | Address | FormName John | 123 Apple Drive | Form1 Form2 Form3 Dave| 133 Westchester Drive | Form1 Form2 Form3 How can I turn this into multiple rows based on that FormName column? So the result would…
mastercool
  • 463
  • 12
  • 35
0
votes
1 answer

What caused Collibra to transition away from Collibra Connect?

As of Dec 2020 in the Collibra Marketplace many tools are showing an alert as to Connect... what would cause this and what impact does it have for Collibra developers? Can't seem to find further details as to the reasons, only signposts to…
olisteadman
  • 442
  • 6
  • 12
0
votes
0 answers

Migrate excel data to postgres database

I'm trying to migrate data from an excel file to postgres but this problem is blocking it.
isawid
  • 35
  • 8