Answer / abhinaw prakash

When we issue Select * from View it'll fetch the data from
the Base table were as with Materialized view when we issue
select * from Materialized view it ll fetch the data from
the materialized view.

Also with using materialized view we can escape the run time
joins that it ll have to do when retrieving for a query.

Also with View you cannot schedule it for refresh but with
MV we can schedule it for Refresh

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

---

Different circumstance which drives informatica server to expel records?

0 Answers  

---

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

---

If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,

---

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---

Hi experts, can anyone tell how much we use plsql in real time

3 Answers  

---

how can import the data from the flat files?

2 Answers  

---

Can we update the data in flat file using update strategy?

3 Answers  

---

Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,

---

How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?

2 Answers   Rolta,

---

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,

---

what is surrogate id ?

3 Answers   IBM,

---