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

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

---

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

---

Explain pushdown optimization and types in informatica

0 Answers   Informatica,

---

what are testing in a mapping level please give brif eplanation

1 Answers   CTS,

---

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

---

Diffrence between static and dynamic cache

2 Answers   HCL,

---

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

---

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers  

---

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers   Patni,

---

what is DSS?

3 Answers  

---

where to select code page option?

2 Answers   TCS,

---