topic Re: Qlik Replicate Global Transformation. in Qlik Replicate

Qlik Replicate Global Transformation.

swatiakasture — Thu, 02 Nov 2023 08:40:21 GMT

Hello,

Is it possible to do all the transformations in qlik replicate as we do in informatica. If it is then please guide.

Thanks.

Re: Qlik Replicate Global Transformation.

KellyHobson — Thu, 02 Nov 2023 08:53:57 GMT

Hey @swatiakasture ,

For comparison, the list of supported global transformations can be found here.

Note - at the table level, there is more functionality with the expression builder.

Best,

Kelly

Re: Qlik Replicate Global Transformation.

OritA — Thu, 02 Nov 2023 08:55:47 GMT

Hi,

I am not sure what are the global transformation that are available in informatica. However, in Replicate you can define different types of global trasformation rules. For more details about it please refer to the Replicate Users guideb FYI below is a link to the relevant section in the documentation:
https://help.qlik.com/en-US/replicate/May2023/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_defGlobalRules.htm

Regards,

Orit

Re: Qlik Replicate Global Transformation.

swatiakasture — Thu, 02 Nov 2023 09:04:02 GMT

Hi OritA,

Thank you for your input.

I am asking whether we can apply some transformations like: union of two source tables and then loading it into target table or like comparing two source table on some condition (Lookup) then loading data into target,etc

such transformations possible in replicate?

Re: Qlik Replicate Global Transformation.

Heinvandenheuvel — Thu, 02 Nov 2023 19:54:28 GMT

>> I am asking whether we can apply some transformations like: union of two source tables and then loading it into target table or like comparing two source table on some condition

NO. Replicate does not have workflow control, not anything but the simplest one-on-one column transformations. The main rule is : One row in, One row out (or none).

One of the transformations available is a singleton select column lookup on source or target, but that doesn't get you very far, is relatively costly in time and resources, and not supported for all targets/source (not for Snowflake target for example - because of the terrible performance it would have)

Replicate is likely a great tool to have in yourr toolbox to move raw, or slightly cleansed data between database servers but it will not be suitable for the tasks you describe. Qlik Compose might help with the next steps from (change) data to warehouse. You may want to work with a Qlik (sales/deployment) consultant to figure out what Replicate can offer for your Environment.

Hein.

Re: Qlik Replicate Global Transformation.

Dana_Baldwin — Thu, 02 Nov 2023 22:19:57 GMT

Hi @swatiakasture

We invite you to please submit your enhancement requests directly to our product management team here: https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas

New capabilities are available with each release, and with our acquisition of Talend that is sure to increase. Please also contact your account manager for product roadmap details and timelines for your needs. If you do not have an account manager you can call +1 (866) 616-4960 or fill out this form here: Contact Qlik Sales | Data Integration and Analytics

Thanks,

Dana