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.

What are the differences between a connected lookup and unconnected lookup?

1014

---

What are the designer tools for creating transformations?

1045

---

What are junk dimensions?

1019

---

what is song in infrmatica...?

2159

---

difference between informatica 8.1.1 and 8.6

3625

---

How we can create indexes after completing the loan process?

1141

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1196

---

wf dont have integration severances how you can run?

1882

---

Explain target update override in informatica

1042

---

Which development components of informatica have the highest usage?

983

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

913

---

What is exclusive and normal mode for repository services?

1061

---

Implementation methodology

1653

---

What are pre and post-session shell commands?

1233

---

What are the transformations that are not supported in mapplet?

954

---