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
- 9477 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shaik
write dql command replace to remove the | and save the result in variable port.find the length of that port by using lenth().....
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / ankit kansal
An Easy Way Of Achieving The Output Will Be :-
select length(column_name)-(length(cloumn_name)-length(replace(column_name,'|',''))) from table_name;
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Howmany ways yoU can update a relational source defintion and what are they?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
In informatics server which files are created during the session rums?
If you want to create indexes after the load process which transformation you choose?
How to update records in Target, without using Update Strategy?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
What is difference between Mapplet and reusable transformation?
Differentiate between a database and data warehouse?
if i am having 10 records in source, i want 20 records in target...how will you do it
Teradata 
