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
- 9548 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
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are active and passive transformations?
is it possible to index the data in cache of lkp transformation ?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Tell me about MD5 functions in informatica
What are the transformations that are not supported in mapplet?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Write the unconnected lookup syntax and how to return more than one column.
Explain the types of lookup transformation?
What are mapplets? How is it different from a Reusable Transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is target load order?
How to extract the informatica rejected data?
Explain pmcmd command usage in informatica
can u any challenge your project?
