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 |
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
What is the advantage of informatica?
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
Can we use parameters of parameter file in presession command
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
how we load the data from source to staging area
where does the default group roew in a router is stored what is the default size of memory in router
hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you
what is galaxy repository?
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
Explain the mapping variable usage example in informatica
What is power play plug in?