Answer / sravanthi

a dimension which cannot be used to describe key performance
indicators is knows as junk dimensions
eg:phno,address..etc

Answer / jani basha

A dimension which can't be used to describe facts is know as junk dimension

Answer / sairam

afact table which contains only flagging values
(indicators) then we will call it as junk dimension

Answer / chandrasekar

In a dimension a particular attribute cannot performed by
any key performance indicator. It is called junk dimension.

For example Phone number is a junk dimension.

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,

---

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

What is workflow monitor?

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,

---

what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,

---

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,

---

difference between shortcut and reusable transformation?

2 Answers  

---

what is update strategy transformation ?

7 Answers   TCS,

---

What are ETL Tools?

0 Answers   Informatica,

---