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/

What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers  

---

What are the tasks that source qualifier performs?

1 Answers  

---

What are batches?

0 Answers  

---

To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  

---

How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,

---

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  

---

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,

---

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,

---

how do u move the code from development to production?

3 Answers  

---

What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,

---

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

---

Can i create a lookup table without cache.

7 Answers   iGate,

---