Answer Posted / prabhu

Source qualifier --> Normalizer --> Expr --> Agg --> target

In Normalizer give the four numeric values as input and then take numeric value and it's GK_value to expression.

In Expression i have made flag for month and hardcoding values of month

Flag_Jan --> IN(GK_Salary,1,5,9,0)
Flag_Feb --> in(GK_Salary,2,6,10,0)
Flag_Mar --> in(GK_Salary,3,7,11,0)
Month --> iif(Flag_Jan = 1,'Jan',iif(Flag_Feb = 1,'Feb',iif(Flag_Mar = 1,'Mar','Aprl')))

In agg group by on month and get sun(numeric value)

Pass month and sum(numeric) value to target

What is rank index in rank transformation?

1129

---

Briefly define a session task?

1195

---

Explain sessions and how many types of sessions are there?

1058

---

Where are the source flat files kept before running the session?

1138

---

State the differences between sql override and lookup override?

1284

---

Performance tuning in UNIX for informatica mappings?

2623

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1818

---

What is the difference between stop and abort in informatica

1142

---

Why do you use Mapping Parameter and mapping variable?

1808

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2070

---

What is a stored procedure transformation?

1113

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

1069

---

What are the data movement modes in informatica?

1208

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1112

---

What is the advantage of informatica?

1124

---