Answer Posted / murali krishna

Transformations can be active or passive.

- An active transformation can change the number of rows
that pass through it, such as a Filter transformation that
removes rows that do not meet the filter condition.

- A passive transformation does not change the number of
rows that pass through it, such as an Expression
transformation that performs a calculation on data and
passes all rows through the transformation.

What is meant by query override?

737

---

Suppose we do not group by on any ports of the aggregator what will be the output?

681

---

Enlist the tasks for which source qualifier transformation is used.

668

---

generate date / time dimension in informatica

800

---

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

787

---

---

What is the fact table?

682

---

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

793

---

Under what condition selecting sorted input in aggregator may fail the session?

749

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1827

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1630

---

What is informatica metadata and where is it stored?

669

---

Sequence generator, when you move from develoment to production how will you reset

1525

---

How do you migrate data from one environment to another?

728

---

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

689

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1567

---