Answer Posted / 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

What is pmcmd command?

1181

---

Explain dynamic target flat file name generation in informatica

1109

---

What is enterprise data warehousing?

1107

---

What is workflow? What are the components of the workflow manager?

1171

---

What are mapplets? How is it different from a Reusable Transformation?

1136

---

In development project what is the process to follow for an etl developer from day1

1758

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1229

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1557

---

EXL informatica Questions

1446

---

What are the static cache and dynamic cache in informatica?

1243

---

What is data caches/ index caches?

1172

---

Explain incremental aggregation in informatica

1185

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2082

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1916

---

what are 3 tech challenges/ common issues you face?

2395

---