What is the difference between Junk and Confirmed Dimention?
where can be used htat one in Informatica?
Answers were Sorted based on User's Feedback
Answer / prabhu
Junk dimension contains the data which are currently not
useful. we have to keep these data for feature analysis
purpose.
Whereas Confirm dimentions are common for multiple fact
table.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sarvesh
merge two or more dimensional tables which are having the
low cardinality colomns into a single table is known
as "junk dimensional tables,
two or more fcat tables can be shared with a single
dimensional table is known as "conformed dimension"
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / chaitanya
An interesting use for a junk dimension is to capture the context of a specific transaction. While our
common, conformed dimensions contain the key dimensional attributes of interest, there are likely
attributes about the transaction that are not known until the transaction is processed.
Is This Answer Correct ? | 0 Yes | 0 No |
Which one is better performance wise connected/un-connected lkp?why?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
What does cheating measurement mean?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
what is mean by throghput? in informatica
In informatica workflow manager, how many repositories can be created?
what is surrogate id ?
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
How to load query faster,so that It will take less time to load?
Why is meant by direct and indirect loading options in sessions?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?