Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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 ‘|’ .

Question Posted / radhabathineni

Answers were Sorted based on User's Feedback



Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|..

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

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|..

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

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|..

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

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|..

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

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|..

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

Post New Answer

More Informatica Interview Questions

Can any one explain or sujjest some sites for scd mappings.Thank you

1 Answers   Wipro,

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

What all join we can perform in LOOKUP transformation?

0 Answers  

what is mapping override?

2 Answers   Cap Gemini,

How to generate sequence numbers?

0 Answers  

how to we create datamart?

2 Answers   HSBC,

How we can create indexes after completing the loan process?

0 Answers  

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

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

1 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories