What is junk dimention?

Answers were Sorted based on User's Feedback



What is junk dimention?..

Answer / krishna

A dimention table which is type of boolean or flag. its not
used in the business analysis

Is This Answer Correct ?    10 Yes 0 No

What is junk dimention?..

Answer / chandrasekar

A Dimension which not participated in the key performance
indicator.

Eg : phone number, address.

If it is wrong means please mail me chandranmca2007@gmail.com

Is This Answer Correct ?    0 Yes 0 No

What is junk dimention?..

Answer / chinmay

Junk dimesnion is aimension table consisting attributes
that do no belong to any fact table or any form of existing
dimesnion .
Usually it is used to hold indicator yes/no , true/false.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

can we use cartesian join in informatica

3 Answers   IBM,


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  


What could be the possible resons of locks by user?

0 Answers  


List the transformation in informatica.

1 Answers   TCS,


Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  






My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,


what is difference between COM & DCOM?

1 Answers   Satyam,


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers  


What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers   Informatica,


write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,


How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.

1 Answers   IBM,


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,


Categories