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.

How many transformations can be used in mapplets.

1977

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1986

---

Explain the types of transformations?

1094

---

scenario where i can use only concurrent execution of workflow.

3252

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1208

---

Explain the tuning lookup transformation - informatica

1041

---

What is the fact table?

1129

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1318

---

How can one identify whether mapping is correct or not without connecting session?

1493

---

Differentiate between router and filter transformation?

1061

---

Design a mapping to load a target table with the following values from the above source?

1390

---

explan ur project architecture?

2125

---

What is flashback table ? Advance thanks

1995

---

What is a filter transformation?

1085

---

What is parallel processing in informatica?

1785

---