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



What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informat..

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

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informat..

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

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informat..

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

Post New Answer

More Informatica Interview Questions

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?

3 Answers   Cap Gemini,


What is the advantage of informatica?

0 Answers  


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?

3 Answers   HP,


Can we use parameters of parameter file in presession command

1 Answers   Wipro,


My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  






how we load the data from source to staging area

4 Answers   TCS,


where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  


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

5 Answers   Patni,


what is galaxy repository?

2 Answers  


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?

7 Answers   Polaris,


Explain the mapping variable usage example in informatica

0 Answers   Informatica,


What is power play plug in?

2 Answers  


Categories