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 the meaning of decode in informatica?

0 Answers  

---

Explain the pipeline partition with real time example?

0 Answers   Informatica,

---

What are the Differences between connected and unconnected lookup?

6 Answers   TCS,

---

how do u tune queries?

1 Answers  

---

How to load a Dimension ? and how to load a fact table?

0 Answers  

---

How will u find weather dimension table is big in size of a fact table?

1 Answers  

---

in which situations do u go for snowflake schema ?

2 Answers   TCS,

---

What is informatica powercenter repository?

0 Answers  

---

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  

---

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

---

expain about the tune parameters?

0 Answers   TCS,

---

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

---