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

Explain the aggregator transformation?

1152

---

What are multi-group transformations?

1086

---

what is mean by complex business rule ?

2154

---

What do you mean by filter transformation?

947

---

How do you use reject loader.

2600

---

What is a sequence generator transformation?

1010

---

What is different between the data warehouse and data mart?

1057

---

How do you promote a non-reusable transformation to reusable transformation?

1132

---

How would you join a node to the already existing domain?

1123

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4725

---

What is the difference between a connected look up and unconnected lookup?

961

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2160

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1242

---

Explain sessions?

1050

---

What are the mapping parameters and mapping variables?

1193

---