Find a way to implement the following logic :
You have column like :
Column 1
AA|BB|CC
DD|EE|FF
WW|AA
I need to get the length of the column without the ‘|’ .
- 5 Answers
- 7944 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhinav prakash
Replacechr(1,Column_name,'|',NULL)..write the query in
expression and pass it to Output.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What all are steps in up gradation of Informatica server?
what is unit testing?tell me proceedure
What are the different ways to implement parallel processing in informatica?
list out all the transformations which use cache?
can anyone explain me about retail domain project in informatica?
What is a snowflake schema?
Please let me know how to make Data masking in informatica..
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How to elaborate tracing level?
What are the designer tools for creating transformations?
What are the new features of informatica 9.x developer?
Can we create two repositories on same database instance in oracle?
Explain direct and indirect flat file loading (source file type) - informatica
Define enterprise data warehousing?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
