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

enterprise datawarehouse your project phase by phase explain?

1 Answers   Cap Gemini,

---

which one is better performance wise joiner or look up

0 Answers   Informatica,

---

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  

---

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,

---

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

---

What are the popular informatica products?

0 Answers  

---

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

---

what is mystery dimension?

1 Answers  

---

Explain in detail about scd type 1 through mapping.

0 Answers  

---

Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

---