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

Explain in detail scd type 2 through mapping.

1029

---

What is the procedure for creating independent data marts from informatica 7.1?

1049

---

Where is metadata stored?

1098

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2178

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1028

---

What is session task and command task?

1267

---

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

1250

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2372

---

What are the new features of informatica 9.x at the developer level?

1030

---

what are the deliverables?in your project?

2133

---

What is the difference between a repository server and a powerhouse?

1492

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2259

---

How does a sorter cache works?

1048

---

Explain why we use partitioning the session in informatica?

1075

---

Performance tuning in UNIX for informatica mappings?

2549

---