Answer Posted / harish konda

connect the Source to sorter and sort the data in Descending
order of salary, department and connect to expression and in
expression generate the sequence of numbers(for eg a port
flag) in such a way that whenever salary changes number
increment to 1, and keep in mind whenever department changes
the numbering should start from 1. And next connect the exp
to Filter and give condition as flag<=2.

What are junk dimensions?

1021

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1026

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

984

---

How to convert multiple rows to single row (multiple columns) in informatica

1319

---

Mention few advantages of router transformation over filter transformation.

982

---

Differentiate between a database and data warehouse?

1093

---

What are the different types of repositories created using informatica?

1062

---

What are the new features of informatica 9.x in developer level?

941

---

What is a transaction control transformation?

1145

---

How can you generate reports in informatica?

973

---

How might one distinguish in the case of mapping is right or not without associating session?

1028

---

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

1988

---

How does the aggregator transformation handle null values?

1087

---

What is joiner change?

1078

---

What is a surrogate key?

1019

---