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.

Global and Local shortcuts. Advantages.

0 Answers  

---

Design a mapping to get year of join for each employee.

4 Answers   Accenture,

---

How u use pdf file in informatica source?

2 Answers   Ericsson, HP, IBM,

---

scd methodology?

2 Answers  

---

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

---

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,

---

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

---

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  

---

i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

---

why we use source qualifier transformation?

16 Answers   Accenture,

---

How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).

5 Answers  

---