topic Re: Question Informatica Equivalent Normalizer Transformation in Talend? in Talend Studio

Question Informatica Equivalent Normalizer Transformation in Talend?

Anonymous — Tue, 22 Oct 2019 17:30:49 GMT

Hello all,

Could you please let me know if there is an equivalent of Informatica Normalizer in Talend studio?

Informatica Normalizer normalizes multiple columns but tNormalize component in Talend does it on only one column appreciate your inputs.

Thank you

Re: Question Informatica Equivalent Normalizer Transformation in Talend?

Anonymous — Wed, 23 Oct 2019 08:37:24 GMT

Hello,

Could you pleas give us your job requirement? In this way, we could see if there is a proper component for your use case.

Elaborating your case with an example with input and expected output values will be preferred.

Best regards

Sabrina

Re: Question Informatica Equivalent Normalizer Transformation in Talend?

Anonymous — Mon, 28 Oct 2019 17:21:26 GMT

For Example i have a single row which i am reading from a DB and while writing into target i want to split 2 of those columns into 2 different rows.

Below i specified with 2 target/expected rows just as an example, some times it could be more than 2 rows (Not Dynamic) depending on no of source columns i want to normalize.

Ex
:: Source Row ::
Loan_id (1234) Reason_Type Cancellation_Date

:: Target Rows ::
Loan_id (1234) Reason_Type
Loan_id (1234) Cancellation_Date

Re: Question Informatica Equivalent Normalizer Transformation in Talend?

manodwhb — Tue, 29 Oct 2019 00:37:36 GMT

you can use tUnpivot custom component ,which is available in Talend Exchange.

And the other way you can do it with tMap by writing an expression, so first generate file and read it if your target is table. That expression should be like row1.Loandid +","+ row1.reason_type+"\n"+ row1.Loanid+","+row1.Cancellation_date

Re: Question Informatica Equivalent Normalizer Transformation in Talend?

Anonymous — Tue, 29 Oct 2019 02:52:07 GMT

Hi
You can refer to this documentation to learn how to install a custom component to talend studio.
https://help.talend.com/reader/2AWmA~w4VvlfP3JC7dTR2w/Kvx1JE1dQGJgGhfFoHK8xA

Regards
Shong