i have a table with name field.
i,e name
Shankar
prabhakar
nitikripa so no
if a occures 3 times in name then it will go to tgt A
if b occures 3 times in name then it will go to tgt b
..
if z occures 3 times in name then it will go to tgt z



i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occ..

Answer / isha

I will write the logic for a and you can use the same logic for all 26 alphabets.

check_a=REPLACECHR(1,Name,'a', NULL) -- 1 means not case sensitive
count_a=LENGTH(NAME)-LENGTH(check_a)


in router group a count_a =3

Pass this to Target

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  


what is metadata?

6 Answers  


write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,


how can you load data into target table without leading zeor's

4 Answers   Deloitte,


Is there any model difference between ODS and DWH

2 Answers   Zensar,






what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,


if we have a delimiters at unwanted places in a flat file how can we over come those.

0 Answers  


What if the source is a flat-file?

0 Answers  


How do you implement configuration management in Informatica?

1 Answers  


How many dimensions are there in informatica?

0 Answers  


is it possible to index the data in cache of lkp transformation ?

0 Answers  


Categories