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 junk dimension

4 Answers   Cap Gemini,

---

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

How do you take back up of repository?

0 Answers  

---

source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,

---

---

is it possible to index the data in cache of lkp transformation ?

0 Answers  

---

Explain what are the different types of transformation available in informatica.

0 Answers  

---

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

---

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

---

Can we create multiple integration service on single repository?

0 Answers  

---

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

---

explain abt joiner t/r?

1 Answers   IBM,

---