Answer Posted / davan

sq-->sort--exp--riuder--tg1--tg2
In exp V_flag=iif(empno=p_empno,v_flag+1,1)--variable port
p_empno=empno--variable port
0_flag=v_flag--output port
In rouder o_flag>1 one target,default one target

what is size of u r database?

2290

---

What are multi-group transformations?

1064

---

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

2365

---

update strategy transformation in informatica

1047

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1116

---

Where is metadata stored?

1092

---

What are the features of complex mapping?

1144

---

r u done any partitions in ur project?

1805

---

Write the different tools in the workflow manager?

1046

---

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

1027

---

Explain scd type 3 through mapping.

959

---

how to create user defined function (udf) in informatica

1284

---

Describe the impact of several join conditions and join order in a joiner transformation?

1046

---

Scheduling properties,whats the default (sequential)

1942

---

In warehouses how many schemas are there?

1056

---