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

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

Question Posted / isha

1 Answers
3402 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What is the format of informatica objects in a repository?

972

What is an expression transformation in informatica?

958

What are the informatica performance improvement tips

1016

Explain pushdown optimization $pushdownconfig parameter - informatica

1078

What are the new features of Power Center 5.0?

1696

Explain what is informatica metadata and where is it stored?

986

How many ways a relational source definition can be updated and what are they?

951

expain about the tune parameters?

2333

How to go to the older version for a mapping?

1027

Explain in detail scd type 2 through mapping.

985

Explain what are the different versions of informatica?

1030

What is intricate mapping?

1088

What are the data movement modes in informatica?

1078

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1864

What is domain in terms of informatica?

951