Answer Posted / vikram

Hey are you guys not informatica resource.. why do you post
answer when you dont know answer.

I have seen this question on many pages and ans give as
Normalizer.

Guys: Correct answer is to use Aggregator..

Normalize : converts rows to column
Agg : Can convert columns to row

What are the types of schemas we have in data warehouse.

945

---

Mention few advantages of router transformation over filter transformation.

1019

---

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

1019

---

can anyone explain me about retail domain project in informatica?

7928

---

What is the meaning of decode in informatica?

1108

---

explain abt ur project architecture?

2170

---

What are the types of lookup transformation?

1058

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5760

---

Differentiate between router and filter transformation?

1000

---

what is $$$$?

2130

---

How to join three sources using joiner? Explain though mapping flow.

1129

---

What are the main issues while working with flat files as source and as targets ?

1140

---

What is substr in informatica?

1180

---

What is joiner change?

1136

---

Why update strategy and union transformations are active?

1029

---