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
- 9294 Views
- I also Faced
- E-Mail Answers
Answer Posted / hariprasad_pulluru
Hi,
You can also parse the string using replace chr to
elminate '|' and find the length of the column
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is parallel processing in informatica?
Is it possible to define a single node as a Gateway node as well as worker node?
What is the need for an etl tool?
What is an active transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
As union transformation gives UNION ALL output, how you will get the UNION output?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the performance considerations when working with aggregator transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the popular informatica products?
Why do we need informatica?
Why filter transformation is an active one?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Write the different tools in the workflow manager?
