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

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,

---

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers  

---

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

---

What are the basic needs to join two sources in a source qualifier?

4 Answers  

---

---

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,

---

What is the way to execute pl/sql script using informatica mapping?

0 Answers  

---

What are the types of groups in Router transformation?

1 Answers   Informatica,

---

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

---

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

---

If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,

---

what is junk dimension

4 Answers   Cap Gemini,

---