What is junk dimention?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
can we use cartesian join in informatica
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What could be the possible resons of locks by user?
List the transformation in informatica.
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?
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.
what is difference between COM & DCOM?
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?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?