Answer Posted / narayanaswami

HI FRIENDS........
Please check this answer....
source table has 2 columns id,name.pass to expression .
remove o/p port in name column,take another port select only o/p port, write code in side of the port
REPLACECHR(0,NAME,'NULL',' ')
pass to target. mapping like

SD=>SQ=>EXP=>TGT.

Briefly describe lookup transformation?

1030

---

What is the Process to creating lookup transformation in informatica

1031

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1935

---

What is the difference between stop and abort in informatica

1070

---

how we can load rejected record's at run time?(not through bad files)

2356

---

What are the modules in Power Center

1666

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1618

---

Explain in detail about scd type 1 through mapping.

1416

---

What is mapplet in informatica?

1038

---

Describe an informatica powercenter?

1106

---

What is a connected transformation?

1093

---

What is the meaning of decode in informatica?

1107

---

What are the different lookup cache(s)?

1094

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5642

---

What does update strategy mean, and what are the different option of it?

1081

---