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.

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,

---

what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,

---

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,

---

can we generate reports in informatica ? How?

3 Answers  

---

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

---

---

What is primary and backup node?

0 Answers  

---

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

---

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

---

Explain the different lookup methods used in informatica?

0 Answers  

---

how to sort date field in infomatica?

2 Answers  

---

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

---

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,

---