Answer / kiran

source-sq-exp-tgt
in exp take two new ports
o1- substr(string,2,1)
o2-concat('20',(substr(string,3)))

let me know if i m wrong

What are mapping parametres and variables in informatica?

6 Answers   TCS,

---

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,

---

How does a sorter cache works?

0 Answers  

---

Define Update Override?

1 Answers  

---

What is the status code in stored procedure transformation?

0 Answers   Informatica,

---

---

How we can create indexes after completing the loan process?

0 Answers  

---

how to create user defined function (udf) in informatica

0 Answers   Informatica,

---

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

---

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  

---

explain about informatica server architecture?

1 Answers   IBM,

---

If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

5 Answers   TCS,

---

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

---