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,

---

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

---

What is different between the data warehouse and data mart?

0 Answers  

---

how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,

---

what are the settiings that u use to cofigure the joiner transformation?

2 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,

---

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

15 Answers   TCS,

---

How might you approve all mappings in the archive all the while?

0 Answers  

---

. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null

3 Answers  

---

what is target update override and when we use it?

2 Answers   TCS,

---

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

---