Answer / hariprasad_pulluru

Hi,

You can also parse the string using replace chr to
elminate '|' and find the length of the column

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().....

Answer / abhinav prakash

Replacechr(1,Column_name,'|',NULL)..write the query in
expression and pass it to Output.

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/

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.

What is the difference between informatica 7.0 and 8.0?

0 Answers  

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

What is informatica metadata and where is it stored?

0 Answers  

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

What are the different threads in DTM process?

1 Answers  

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

What are the challenges of Dataware housing in the future?

2 Answers   HP,

what r the values tht r passed between informatics server and stored procedure?

1 Answers  

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

1 Answers   HTC, TCS,