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
- 7896 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 |
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
How can you increase the performance in joiner transformation?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Whats the difference between informatica powercenter server, repositoryserver and repository?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
What is a taget load order?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
how to move the mappings from your local machine to claint place?
What is Cognos script editor?
Teradata 
