Answer Posted / sai.masarapu.chowdary

using normalizer transformation we can do as follows:

from source qualifier give the column to the normalizer tr
then put occur for 4 times.

put that occurs to the target. thats it..

Differentiate between router and filter transformation?

952

---

explain abt ur project architecture?

2122

---

What is informatica? Why do we need it?

1039

---

what is diff b/t sorter t/r and agg have the option sorter property...

2129

---

What does “tail –f” command do and what is its use as an Informatica admin.

1029

---

What is aggregate cache in aggregator transformation?

1061

---

What is persistent lookup cache?

966

---

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 ?

2121

---

how to load rows into fact table in data warehouse

1115

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1050

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1057

---

How to create a non-reusable instance of reusable transformations?

1058

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1950

---

Enlist few areas or real-time situations where informatica is required.

1020

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1926

---