Answer / abhishek kumar

In aggregator
id group by;
o_name -> max(name);
o_location-> max(location);
o_salary-> max(salary);

connect id to id(target),o_name to name(target),o_location
to location(target),o_salary to salary(target) port;
src->sq->aggregator->target

Answer / rajan raorane

Use the below Mapping


Flat file-->SRC Qualif-->EXp-->Filter( With not null
condition on each port)-->Normalizer-->output

checkout and checkin in informatica 8.6

3 Answers   TCS,

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---

What is power center repository?

1 Answers  

---

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,

---

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

---

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

---

What are the tuning techniques you applied during your last project

0 Answers  

---

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

---

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

---

What is the function of aggregator transformation?

0 Answers  

---

Explain the types of transformations?

0 Answers  

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

---