1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

---

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,

---

What is exclusive and normal mode for repository services?

0 Answers  

---

Name the different lookup cache(s)?

0 Answers  

---

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

---

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

---

How many repositories can we create in Informatica??

9 Answers   IBM, Patni,

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

---

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

---

Different sorts of metadata that stores in the storage facility?

0 Answers  

---

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

---

How many cubes create from a single model?

1 Answers  

---