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
- 9529 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 aggregate cache in aggregator transformation?
What are the measure objects?
What do you mean by enterprise data warehousing?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is the difference between source qualifier transformations source filter to filter transformation?
difference between repository database and repository service?
How do you set a varible in incremental aggregation
Define joiner transformation?
Explain the difference between mapping parameter and mapping variable?
How to configure mapping in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Why do we need informatica?
What is sequence generator transformation in informatica?
