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.

What is synonym?

2 Answers   Patni,

---

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

---

Can i create a lookup table without cache.

7 Answers   iGate,

---

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

---

Why do you use Mapping Parameter and mapping variable?

0 Answers  

---

---

which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,

---

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,

---

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 Answers   CSC,

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

0 Answers   Amazon,

---

Tell me about Propagate functions in informatica

0 Answers  

---

What is the difference between stop and abort in informatica

0 Answers   Informatica,

---