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
- 9736 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
We can find the position of the "|" using INSTR function and
then we can use the SUBSTR function to extract the strings.
We can use Normalizer t/r to put the strings in one column
and then use LENGTH function to find the length of the string.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is transformation?
How can informatica be used for an organization?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Where are the source flat files kept before running the session?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What do think which one is the better joiner or look up?
What are the static cache and dynamic cache in informatica?
what is the -ve test case in your project.
What are multi-group transformations?
How do you promote a non-reusable transformation to reusable transformation?
What are the components of workflow manager?
What are the types of caches in lookup? Explain them.
What is olap (on-line analytical processing?
What is workflow? What are the components of the workflow manager?
