How to get rid of non ascii characters in a string?
Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件
to
United States Microsoft Visual Studio Tools for Applications 2012 x86.
Answer / aa
Use reg_replace
reference
https://etltechsolutions.wordpress.com/
| Is This Answer Correct ? | 2 Yes | 0 No |
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
Can informatica load heterogeneous targets from heterogeneous sources?
what is the necessity to use update strategy?(except for updates)
how many types of dimensions are available in informatica?
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........
what transformations are used for Variable port?
How we will implement Pushdown Optimization and Types in Informatica with better examples
what is the complex transformation you used in informatica
Whats there in global repository
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?