This blog contains Informatica tutorials, Complete reference to Informatica, Informatica Tutorial for Beginners, Informatica Real Time Scenarios with Answers, Informatica Interview Questions with Answers, Informatica FAQ, TIPS for learning Informatica, Learn Informatica online, Informatica Guide for Beginners, DWH Concepts, Informatica scenarios, Informatica Scenario Based Interview Questions with Answers, Informatica scenarios with solutions, Informatica Latest scenarios with answers
Suppose in flat_file some special symbols like @,%,$,#,& has added in empno column along with the actual data. How to remove those special charcters ? ( see article , on how to remove $ from salary ) example
empno in source empno(in string format) 7@3%$,21 432#@1 324&*,$2 In target empno 7321 4321 3242 Following are the steps for achieving this mapping
Connect 0/p columns of SQF to an expression transformation.
In expression make empno as input and create another port empno1 as output port with date datatype. And in empno1 write condition like this. and finally send it to target
You comments and suggests keeps me going, don't forget to do so.