Hope you all are doing well.
I am new to the informatica and i need to solve one use case
Below are the details :
Input Data :
|Account ID - 18 Digit||Billing Country||Global Customer Name||OP_Column|
|001f200001eQHSjAAO||AU||Fujitsu Ltd||Fujitsu Ltd|
|0013000000CVFqnAAH||AU||APNIC Pty Limited||APNIC Pty Ltd|
|0013000000BkbT2AAJ||IN||S4 Consulting Limited||S4 Consulting Ltd.|
|0016000000y6pyOAAQ||IN||GWR GROUP Ltd||GWR GROUP Ltd.|
Whenever there is a LTD or Limited i need to change this to Ltd. for all countries except australia for now i have used reference table to change the Limited and Ltd to Ltd. but i m not sure how to do this for Australia country with reference table.
Appreciate your quick help
Thanks & Regards,
This answer seems to be super late for you but if the question is not yet resolved, you cannot do conditional standardization of values using reference table.
In your case you can route non Australia records through standardizer/lookup for your LTD /Limited fixes and merge them further into 1 pipeline.