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
- 9300 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
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
what is SDLC way of code development?
Differentiate between a database and data warehouse?
What are the tasks that source qualifier perform?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the different options available for update strategy?
can anyone suggest best free Talend data integration training online
What are pre and post-session shell commands?
Is there any target staging area in informatica not staging area
What are the main issues while working with flat files as source and as targets ?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Under what condition selecting sorted input in aggregator may fail the session?
To import the flat file definition into the designer where should the flat file be placed?
What is a grid in Informatica?
