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

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,


During the running session, output files are created by informatica server. Enlist few of them.

0 Answers  


scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  


what is workflow varible

1 Answers   HP,


My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,






While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  


Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,


Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,


What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers  


What are the different types of repositories created using informatica?

0 Answers  


i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,


What is informatica? What exactly are the practical uses in real world

2 Answers  






Categories