Talend - ELT Netezza - shuffle and mask

[Anonymous]

Hi,

I have experience in using Talend for Oracle ETL project where we have used masking and shuffling components.

Is there a similiar component for Netezza ELT - as the table has huge volume and we have got the requirement to mask the test data?

Kindly advice if it is possible to implement these techniques in ELT.

Thanks

[Anonymous]

Hi,

    A sample scenario of Netezza ELT is available in below link.

https://help.talend.com/reader/GX8piOAznHLptJR8efI4Iw/hd4RDTiVXb719j5t1g8AnQ

    Did you try tDataMasking component to do the masking in this flow? What is the error you are getting?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Does the data have to be masked before processed by talend? Or do you want talend to perform masking and store in some other table?

[Anonymous]

Hi,

   You can do the data masking within Talend itself.

    Are you facing any issue while using the masking component?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hello,

The ELT components are having link as the connector and the shuffle and mask components expect rows as connector, and so these don't connect.

Is there a way to combine ELT component with ETL components for Netezza - tDataMasking and tDataShuffling?

(or)

Is it possible to use a buffered output as source and ELT output component for target?

(or)

Netezza is being used as Datawarehouse component and so the volume is huge(around 2 billion).

Could you suggest how to do masking and shuffling techniques here

Thanks.