Answer Posted / abhinaw prakash

1.Pass the coulmns to an expression transformation.
2.Create a variable port and use INSTR function to find the
location of @.
(INSTR(CNAME,'@')-1)
3.Create an output port and use SUBSTR function to extract
the substring from the string.
SUBSTR(CNAME,1,v_CNAME)
4.Pass it to the output port

what are 3 tech challenges/ common issues you face?

2282

---

Can we get 1st record through Informatica(without sequence number).

1411

---

What is mapplet in informatica?

983

---

Why sorter is an active transformation?

1131

---

What is native users?

1102

---

Briefly define reusable transformation?

1077

---

What is the commit type if you have a transaction control transformation in the mapping?

973

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2689

---

Explain the different kinds of facts.

935

---

Explain the informatica workflow?

1005

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1007

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

2237

---

How are indexes created after completing the load process?

1549

---

Define pmcmd command?

994

---

What is difference between a gateway node and worker node?

1069

---