Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9309 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 is DR strategy for Informatica project?
Under what condition selecting sorted input in aggregator may fail the session?
Which are the different editions of informatica powercenter that are available?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is native users?
r u done any partitions in ur project?
Explain what are the different versions of informatica?
What does “tail –f” command do and what is its use as an Informatica admin.
What are batches?
How does the aggregator transformation handle null values?
What do mean by local and global repository?
What is workflow? What are the components of the workflow manager?
generate date / time dimension in informatica
what is degenerated dimension?
