Thank you Lokesh for starting this poll. My name is Joel LaPlount and I work at Informatica in the Product Marketing team. I can help support your virtual meetings by finding Informatica speakers on topics your group would like to hear more about.
Hello Team, 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…(Show moreShow less)
Priyanka, 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.
IF LUP=NULL then COD, if not then check if LUP<=COD, if COD is greater than equal to LUP, then COD else LUP? I want the above statement to be converted into an expression so that, I can use this in Expression Transformer of Informatica.