Answer / keshav

CREATE AN EXPRESION TALE 2 VARIABLE AND 2 OUTPUT PORTS

FOR VARIABLE PORTS WRITE THE BELOW EXPRESSIONS

V_NAME(v)=IIF((IIF(ISNULL(ID),V_ID,ID)=V_ID),V_NAME || ' ' || NAME,NAME )

V_ID(v)=IIF(ISNULL(ID ) , V_ID, ID )

OUT_ID(o)=V_ID
OUT_NAME(o)=V_NAME

AFTER TAKE AGGREGATER AND SELECT OUT_ID AS GROUP BY PORT

AFTER CONNECT TO TARGET

Answer / 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.

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

---

What are pre and post-session shell commands?

0 Answers  

---

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

---

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

---

List the transformation in informatica.

1 Answers   TCS,

---

Define mapplet?

0 Answers  

---

How to recover sessions in concurrent batches?

3 Answers  

---

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,

---

what is mapping override?

2 Answers   Cap Gemini,

---

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

---

what is mapping parameter?

2 Answers   Cap Gemini,

---

What are multi-group transformations?

0 Answers   Informatica,

---