Answer / siddu

For fast retrieval(to Perform a SELECT Operation)

Answer / vikki

GENERALLY IN DWH, WE DO SELECT QUERY ONLY(99%)..
SO THE DATA ARE NOT NEED TO BE NORMALIZED AS IN DB WHERE WE DO UPDATE,SELECT,ALTER,ETC..

Answer / ankit kansal

As a denormalized table structures for a database the number
of joins to fetch the data turns out to be less and hence selection to the data becomes faster.

selecting data from one table is always better than selecting the same data from multiple tables.


http://deepinopensource.blogspot.in/

Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 Answers  

---

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

---

Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani

2 Answers   Wipro,

---

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

---

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,

---

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,

---

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 Answers  

---

On which transformations you created partitions in your project?

0 Answers   Cap Gemini,

---

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,

---

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

---

What is the status code in stored procedure transformation?

0 Answers   Informatica,

---

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

---