Question Informatica Equivalent Normalizer Transformation in Talend?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[manodwhb]

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

[Anonymous]

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